Tuesday, March 27, 2012

Distinguish SQLServer and MSDE instances

How can I tell which of the SQLServers listed on the network are
specifically MSDE.
I want to make sure that I have licenses for all the full versions of
SQLServer that are running.
Thanks.
Alan
Issue one of the commands on the servers you want to find that out:
Select @.@.Version
--OR
EXEC master..xp_msver
HTH, Jens Suessmeyer
|||Another command would be to SELECT SERVERPROPERTY('Edition');
http://msdn.microsoft.com/library/?u...asp?frame=true
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Jens & Alan,
Thanks very much.
Regards,
Alan
"Alan Z. Scharf" <ascharf@.grapevines.com> wrote in message
news:Ol87ezb6FHA.3276@.TK2MSFTNGP10.phx.gbl...
> How can I tell which of the SQLServers listed on the network are
> specifically MSDE.
> I want to make sure that I have licenses for all the full versions of
> SQLServer that are running.
> Thanks.
> Alan
>
>

No comments:

Post a Comment