10 February 2007

February 10 How to identify your SQL Server version, level and edition

Unlike other Microsoft products, it’s not possible to just click “Help/About” to get the version and edition information of your SQL Server installation. I was curious about mine and searched around. I found this MSDN article that describes how it’s done for each version of SQL Server. For SQL Server 2005 the query syntax is (courtesy of MSDN):
SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)
Or you could just download and execute my query file from the SQL Management Studio.


No comments:

Post a Comment

Comments are moderated only for the purpose of keeping pesky spammers at bay.

SharePoint Remote Event Receivers are DEAD!!!

 Well, the time has finally come.  It was evident when Microsoft started pushing everyone to WebHooks, but this FAQ and related announcement...