all groups > sql server mseq > july 2003 >
You're in the

sql server mseq

group:

How to find service pack version SQL2000


How to find service pack version SQL2000 Bernard
7/23/2003 8:11:12 AM
sql server mseq: Hello,
Anyone know how to retrieve SP version info in SQL 2000?

thank you in advance.

Re: How to find service pack version SQL2000 Vishal Parkar
7/23/2003 9:14:46 AM
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185

--
-Vishal
[quoted text, click to view]

How to find service pack version SQL2000 Ratna
7/29/2003 11:54:15 AM
Hi,
Try running "select @@Version" in the query analyzer.
It will give the version and the service pack loaded.

Thanks
Ratna

[quoted text, click to view]
How to find service pack version SQL2000 Ray Higdon
7/29/2003 2:45:32 PM
My favorite: select serverproperty('productlevel')

HTH

Ray Higdon MCSE, MCDBA, CCNA

[quoted text, click to view]
AddThis Social Bookmark Button