10 February 2007

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.
Later
C

No comments:

Post a Comment

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

Microsoft Authentication Library (MSAL) Overview

The Microsoft Authentication Library (MSAL) is a powerful library designed to simplify the authentication process for applications that conn...