October 12, 2007 at 2:50 pm
Hello all,
How do I tell if I have the most current MS updates/service packs for SQL? I am using SQL 2000. Thanks in advance:)
October 12, 2007 at 7:54 pm
SELECT @@VERSION
Then, check the Microsoft site for the build number...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 16, 2007 at 9:20 am
I think you can as well use --SELECT SERVERPROPERTY('ProductLevel')-- to get the sevice pack applied.....
Renuka__
[font="Verdana"]Renuka__[/font]
October 16, 2007 at 12:02 pm
Thank you! That worked perfectly!:)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply