How to check the SQL Server Version and Edition

If you ever wanted to know what version of Microsoft SQL Server and Edition you are running then Microsoft is maintaining really nice knowledgebase on this subject.

http://support.microsoft.com/kb/321185

For SQL Server 2000 and later, use following SQL query to check the version and edition..

SELECT SERVERPROPERTY(‘productversion’) as Version, SERVERPROPERTY (‘productlevel’) as SP, SERVERPROPERTY (‘edition’) as Edition

For SQL Server 7.0 and earliar, use following SQL query to check the version. Please note that do not use this command on the SQL Server 2000 and later. It may return the information but may incorrect at times.

SELECT @@VERSION

Look at the Microsoft KB article for more detailed information.

Nik

Advertisements
This entry was posted in SQL Server. Bookmark the permalink.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s