5.4. @@VERSION
5.4.1. Identifying Version and Service Pack
Run SELECT @@version.
SQL |
---|
SELECT @@version
|
Result |
---|
------------------------------------------------------------------Microsoft SQL Server 2000 - 8.00.534 (Intel X86)May 23 2001 00:02:52Copyright (c) 1988-2000 Microsoft CorporationPersonal Edition on Windows NT 5.0 (Build 2195: Service Pack 1) |
8.00.532 on the first line contains “8.00” which indicates you have MSS 2000 (8.0). The numbers “532” are the three digits specifying which Service Pack level is installed:
MSS 2000 Version and Service Pack Information
• MSS 2000 with no SP: | 8.00.194 |
• MSS 2000 with SP 1: | 8.00.384 |
• MSS 2000 with SP 2: | 8.00.532 or 534 |
• MSS 2000 with SP 3 or 3a: | 8.00.760 |
MSS 7.0 Version and Service Pack Information
Get Transact-SQL Desk Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.