HOW TO: Identify Your SQL Server Service Pack Version and Edition
From Query Analyzer run
Code:
SELECT @@VERSION
SQL Server 2005 (Code name Yukon)
9.00.1399.06 SQL Server 2005 Release to Manufacturing (RTM)
9.00.1314.06 SQL Server 2005 Community Technical Preview (CTP Sept 2005)
9.00.1187.00 SQL Server 2005 Community Technical Preview (CTP June 2005)
9.00.1116.00 SQL Server 2005 Community Technical Preview (CTP April 2005)
SQL Server 2000 (Code name Shiloh)
8.00.2039.0 SQL Server 2000 SP4
8.00.818.0 SQL Server 2000 SP3a with hotfix/cumulative patch (KB #821277 )
8.00.760.0 SQL Server 2000 SP3a
8.00.760.0 SQL Server 2000 SP3
8.00.534.0 SQL Server 2000 SP2
8.00.384.0 SQL Server 2000 SP1
8.00.287.0 SQL Server 2000 RTM + KB #297209
8.00.194.0 SQL Server 2000 RTM (SQL Server release to manufacturing)
SQL Server 7.0 (Code name Sphinx)
7.00.1063 SQL Server 7.0 Service Pack 4 (SP4)
7.00.961 SQL Server 7.0 Service Pack 3 (SP3)
7.00.842 SQL Server 7.0 Service Pack 2 (SP2)
7.00.699 SQL Server 7.0 Service Pack 1 (SP1)
7.00.623 SQL Server 7.0 RTM (Release To Manufacturing)
SQL Server 6.5 (Code name Hydra)
6.50.479 SQL Server 6.5 Service Pack 5a (SP5a) Update
6.50.416 SQL Server 6.5 Service Pack 5a (SP5a)
6.50.415 SQL Server 6.5 Service Pack 5 (SP5)
6.50.281 SQL Server 6.5 Service Pack 4 (SP4)
6.50.258 SQL Server 6.5 Service Pack 3 (SP3)
6.50.240 SQL Server 6.5 Service Pack 2 (SP2)
6.50.213 SQL Server 6.5 Service Pack 1 (SP1)
6.50.201 SQL Server 6.5 RTM
SQL Server 6.0
6.00.151 SQL Server 6.0 Service Pack 3
6.00.139 SQL Server 6.0 Service Pack 2
6.00.124 SQL Server 6.0 Service Pack 1
6.00.121 SQL Server 6.0 RTM
The results are:
• The product version (for example, "9.00.1399.06").
• The product level (for example, "RTM").
• The edition (for example, "Enterprise Edition").
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest (c) 2006 by Group29 Productions.
You can syndicate Group29 Productions news with an RSS Feeder using the file backend.php