Friday, March 23, 2012

How to tell which edition of SQL Server 2005 is installed?

Since there are several different editions of SQL Server 2005, how can I find out which edition is installed? Is there a command or a menu item that can display this information? Help->About only gives the version number, not the edition name. I needed to find out whether the SQL Server 2005 on a machine is the Enterprise edtion or not.

Thanks,
Dandan

If you have Database Services installed, you can run T-SQL query "PRINT @.@.version" to find out.|||

This works great. Thanks very much :)

Dandan

No comments:

Post a Comment