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.