Issue one of the commands on the servers you want to find that out:

Select @@Version

--OR

EXEC master..xp_msver


HTH, Jens Suessmeyer

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

Another command would be to SELECT SERVERPROPERTY('Edition');

http://msdn.microsoft.com/library/?url=/library/en-us/tsqlref/ts_sa-ses_3mi1.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
[quoted text, click to view]