dbTalk Databases Forums  

How to find service pack version SQL2000

microsoft.public.sqlserver.mseq microsoft.public.sqlserver.mseq


Discuss How to find service pack version SQL2000 in the microsoft.public.sqlserver.mseq forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Bernard
 
Posts: n/a

Default How to find service pack version SQL2000 - 07-23-2003 , 10:11 AM






Hello,
Anyone know how to retrieve SP version info in SQL 2000?

thank you in advance.

bernard

Reply With Quote
  #2  
Old   
Vishal Parkar
 
Posts: n/a

Default Re: How to find service pack version SQL2000 - 07-23-2003 , 10:14 AM






http://support.microsoft.com/default...;en-us;q321185

--
-Vishal
"Bernard" <bmcrae (AT) atlam (DOT) com> wrote

Quote:
Hello,
Anyone know how to retrieve SP version info in SQL 2000?

thank you in advance.

bernard



Reply With Quote
  #3  
Old   
Ratna
 
Posts: n/a

Default How to find service pack version SQL2000 - 07-29-2003 , 01:54 PM



Hi,
Try running "select @@Version" in the query analyzer.
It will give the version and the service pack loaded.

Thanks
Ratna

Quote:
-----Original Message-----
Hello,
Anyone know how to retrieve SP version info in SQL 2000?

thank you in advance.

bernard
.


Reply With Quote
  #4  
Old   
Ray Higdon
 
Posts: n/a

Default How to find service pack version SQL2000 - 07-29-2003 , 04:45 PM



My favorite: select serverproperty('productlevel')

HTH

Ray Higdon MCSE, MCDBA, CCNA

Quote:
-----Original Message-----
Hello,
Anyone know how to retrieve SP version info in SQL 2000?

thank you in advance.

bernard
.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.