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.