Microsoft Update for SQL Server yet?
-
Can anyone tell me whether I have to periodically check for Service Packs for SQL server 2000 and SQL Server 2005? I have upgraded my machines to use automatic Microsoft Update (the more expansive one than Windows Update) but it seems I have to still check on SQL Server.
The associated question is what's the fastest way to get SS to tell me what SP level it is at?
-
SELECT ServerProperty('ProductVersion'),
ServerProperty('ProductLevel')
That will give you the version (ie. 8.00.760 - which means SQL Server 2000 SP3) and the level (service pack) you are at. The version format lets you also know what hotfix level you are at.
There's a conversion chart at http://www.sqlsecurity.com. Find the FAQ/DOC link and you want the SQL Server Version Database.
-SQLBill
-
And yes, you do have to periodically check for updates.
-SQLBill
-
Thanks. I guess making it easy isn't on the hit list! (e.g. why would it not just say, SP3? Duh.)
-
Using the ProductLevel will return just SP3. But ProductVersion lets you know if you have any hotfixes installed also. For example: 8.00.819 is SP3 + Q826161.
-SQLBill
-
Thanks
-
here's a copuple of handy links as well:
http://support.microsoft.com/default.aspx?scid=kb;en-us;321185#E6ADAAA
http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply