Sean
 |
| 04/13/2005 8:21 AM |
 Quote
 Reply
 Alert
|
| Is there an easy way of identifying the patch level of a SQL server? |
|
|
|
|
Chip Andrews
|
| 04/13/2005 7:35 PM |
Quote
Reply
Alert
|
| If you can log into it - just go a 'select @@version' OR xp_msver ProductVersion and get 100% accuracy.
OR
If you can access the file system you could get the file version for sqlservr.exe
OR
If you can't then you can use sqlver.exe (on this site) which will give you the ssnetlib version without logging in which is still about 70-80% accurate.
Chip
|
|
|
|
|
Seán
|
| 04/14/2005 8:47 AM |
Quote
Reply
Alert
|
| Thanks Chip but I still can't determine the Service Pack level...
Ώ] select @@version - tells me the version but not the SP level:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Evaluation Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
Ώa] xp_msver ProductVersion returns:
ProductVersion 524288 8.00.760
ΐ] File version for sqlsevr.exe:
2000.80.760.0
Α] SQLver.exe
- needs the .NET framework (not allowed to install on this particular server!)
|
|
|
|
|
Sean
|
| 04/15/2005 5:03 AM |
Quote
Reply
Alert
|
| http://vyaskn.tripod.com/sqlsps.htm
Tells me that I'm on SP3 / SP3a!
:) |
|
|
|
|
Chip Andrews
|
| 04/17/2005 8:42 PM |
Quote
Reply
Alert
|
| Or just compare the version to this chart to see what the SP level is:
https://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
|
|
|
|
|