How to find service pack version SQL2000

#1

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

thank you in advance.

bernard

#2

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

#3

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
.

#4

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
.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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