SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Checking SQL Server Versions

This question comes up enough on the forums and with SP1 for SQL Server 2005 released, I'll cover it again. You can get the version by unning SELECT @@VERSION on your SQL Server. The query will return something similar to:

Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)
    Apr 14 2006 01:12:25
    Copyright (c) 1988-2005 Microsoft Corporation
    Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

The key is to look at the version # I have highlighted. You can determine what the version # corresponds to with respect to service packs and hotfixes here:

SQLSecurity.com: SQL Server Version Database

Microsoft does provide an official list, but it isn't as comprehensive, nor does Microsoft seem to keep it up-to-date as well as Chip Andrews keeps his. You can find it here:

Microsoft KB article: How to identify your SQL Server version and edition

For instance, as of this post the KB article doesn't include SQL Server 2005 SP1 in the list because the article was last reviewed on December 13, 2005.

K. Brian Kelley - Databases, Infrastructure, and Security

IT Security, MySQL, Perl, SQL Server, and Windows technologies.


No comments.

Leave a Comment

Please register or log in to leave a comment.