No indication of the SQL Server edition in the About window

I installed the SQL Server 2005 standard edition after uninstalling the Express edition.

When i look in the 'About' screen in the 'SQL Server Managment studio', i don't see indication that the SQL Server 2005 i currently work with is the Standard Edition. There are only categories and their numbers of versions.

How do i know that the Edition i work on ,now , is the Standard edition ?

Open up Management Studio and run "select @.@.version". This will tell you your SQL and OS details, including edition.

Thanks,
Sam Lester (MSFT)

|||Thanks , works like a charm.

No Agent Indication

How can I tell if my SQL Server Agent is running without using the EM? The
network admins have control of the server in such a way as to not let the DBA
start or stop the service on the server. This of course does not light up
the indicator in the EM for the Agent.
Hi
If you run sp_who2 or query sysprocesses, you will see connections from
Agent. They are always there as they poll for jobs.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:D060BCE2-BE0D-493A-81FD-C0E7E18C9E15@.microsoft.com...
> How can I tell if my SQL Server Agent is running without using the EM?
> The
> network admins have control of the server in such a way as to not let the
> DBA
> start or stop the service on the server. This of course does not light up
> the indicator in the EM for the Agent.

No Agent Indication

How can I tell if my SQL Server Agent is running without using the EM? The
network admins have control of the server in such a way as to not let the DBA
start or stop the service on the server. This of course does not light up
the indicator in the EM for the Agent.Hi
If you run sp_who2 or query sysprocesses, you will see connections from
Agent. They are always there as they poll for jobs.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:D060BCE2-BE0D-493A-81FD-C0E7E18C9E15@.microsoft.com...
> How can I tell if my SQL Server Agent is running without using the EM?
> The
> network admins have control of the server in such a way as to not let the
> DBA
> start or stop the service on the server. This of course does not light up
> the indicator in the EM for the Agent.sql

No Agent Indication

How can I tell if my SQL Server Agent is running without using the EM? The
network admins have control of the server in such a way as to not let the DB
A
start or stop the service on the server. This of course does not light up
the indicator in the EM for the Agent.Hi
If you run sp_who2 or query sysprocesses, you will see connections from
Agent. They are always there as they poll for jobs.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:D060BCE2-BE0D-493A-81FD-C0E7E18C9E15@.microsoft.com...
> How can I tell if my SQL Server Agent is running without using the EM?
> The
> network admins have control of the server in such a way as to not let the
> DBA
> start or stop the service on the server. This of course does not light up
> the indicator in the EM for the Agent.