Q: How do I know what service pack is on there for SQL?

Q: How do I know what service pack is on there for SQL?

Post by Brian Bozart » Tue, 31 Jul 2001 23:15:44




do I look?  This is what I got.

Microsoft SQL Server  7.00 - 7.00.623 (Intel X86)
 Nov 27 1998 22:20:07
 Copyright (c) 1988-1998 Microsoft Corporation
 Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 6)

 
 
 

Q: How do I know what service pack is on there for SQL?

Post by Dinesh.T.K » Tue, 31 Jul 2001 23:29:32


Brian,

623--No SP.

For general info run this script:

---

SET NOCOUNT ON




-- 6.5
WHEN '121' THEN 'NO SP'
WHEN '124' THEN 'SP1'
WHEN '139' THEN 'SP2'
WHEN '151' THEN 'SP3'
WHEN '201' THEN 'NO SP'
WHEN '213' THEN 'SP1'
WHEN '240' THEN 'SP2'
WHEN '252' THEN 'SP3 ** BAD **'
WHEN '258' THEN 'SP3'
WHEN '259' THEN 'SP3 + SBS'
WHEN '281' THEN 'SP4'
WHEN '297' THEN 'SP4 + SBS'
WHEN '339' THEN 'SP4 + Y2K'
WHEN '415' THEN 'SP5 ** BAD **'
WHEN '416' THEN 'SP5a'
-- 7.0
WHEN '198' THEN 'Beta 1'
WHEN '517' THEN 'Beta 3'
WHEN '583' THEN 'RC1'
WHEN '623' THEN 'NO SP'
WHEN '689' THEN 'SP1 Beta'
WHEN '699' THEN 'SP1'
WHEN '835' THEN 'SP2 Beta'
WHEN '842' THEN 'SP2'
WHEN '961' THEN 'SP3'
-- 2000
WHEN '194' THEN 'NO SP'
WHEN '384' THEN 'SP1'
ELSE 'Unknown - may be a Hot-Fix version or script out of date'
END AS 'SERVICE PACK'
set nocount off

--

Dinesh.

 
 
 

1. which sql service pack am i running?


Microsoft SQL Server  7.00 - 7.00.623 (Intel X86)
 Nov 27 1998 22:20:07
 Copyright (c) 1988-1998 Microsoft Corporation
 Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 4)

I had a look at: http://www.serverfaq.com/ntfaq/sql28.html to check but I
can't work it out - according to this I have SQL Server 7.0 "gold" release -
what the heck is gold release?? I'm sure I installed SP2 on it.  Certain in
fact.  I'm also sure I installed NT SP6a as well - what's going on?

Thanks,

Paul

2. Oracle/Sybase developers in NY Area

3. How do I know what service pack I have on SQL 6.5

4. 4th Dimension and Foxbase+

5. How do I know the version of the service pack installed to SQL

6. Registration Number

7. What service pack am I on now????

8. ASCII Export/Import VCL components

9. which service pack am I running?

10. What Service Pack level am I at???

11. Known problems with Service Pack 5a........

12. Do You know any problem after install Service Pack 3 for OLAP

13. How do I know what Service Pack is Installed for MSDE 2000