Identify version by running query:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Look up on list below:
RTM 90.1399
SQL Server 2005 Service Pack 1 90.2047
SQL Server 2005 Service Pack 2 90.3042
SQL 2000 has similar query with the following versions:
RTM 80.194.0
SQL Server 2000 SP1 80.384.0
SQL Server 2000 SP2 80.534.0
SQL Server 2000 SP3 80.760.0
SQL Server 2000 SP3a 80.760.0
SQL Server 2000 SP4 8.00.2039
No comments:
Post a Comment