Most organizations have multiple SQL Server systems installed, and now that Microsoft has released several different service packs for SQL Server 2005, chances are you’re also running multiple versions. This can be a problem because some features require a minimum service pack level. For instance, database mirroring requires a minimum of SQL Server 2005 SP1. Get a handle on what versions you’re running by following the steps below.

  • To determine what version of SQL Server 2005 you’re running, open SQL Server Management Studio (SSMS), then start Query Editor. If you’re running SQL Server 2000 or earlier, open Query Editor. Next, execute the following T-SQL query:

SELECT @@version

  • If you want more complete product information, run the following query:

SELECT SERVERPROPERTY
(‘productversion’), SERVERPROPERTY
(‘productlevel’), SERVERPROPERTY
(‘edition’)

This query will return the SQL Server version number, the product level (e.g., RTM or SP), and the name of the SQL Server edition. See the table for a list of the recent production version numbers for SQL Server 7.0 through SQL Server 2005 SP2.

You can find a complete list of the different version numbers for all of the different releases of SQL Server at support.microsoft.com/kb/321185.