A quick tip- how to find
out what version and service pack of SQL Server a server is running:
SELECT SERVERPROPERTY('ProductVersion') AS SqlServerVersion,SERVERPROPERTY( 'ProductLevel') AS ServicePack
Here are the versions
and their corresponding build numbers for 2000 and 2005.
|
RTM
|
2000.80.194.0
|
|
SQL Server 2000 SP1
|
2000.80.384.0
|
|
SQL Server 2000 SP2
|
2000.80.534.0
|
|
SQL Server 2000 SP3
|
2000.80.760.0
|
|
SQL Server 2000 SP3a
|
2000.80.760.0
|
|
SQL Server 2000 SP4
|
2000.8.00.2039
|
|
RTM
|
2005.90.1399
|
|
SQL Server 2005
Service Pack 1
|
2005.90.2047
|
|
SQL Server 2005
Service Pack 2
|
2005.90.3042
|
No comments:
Post a Comment