For SQL 2000

8.00.194 base
8.00.534 sp2

I don't know sp1

-----Original Message-----
From: Herrera, Jorge [mailto:[Email Address Removed] Monday, July 08, 2002 1:48 PM
To: 'gary cheng'; [Email Address Removed] RE: SQL Version
Importance: High


Gary,

If you have MSSQL7 here is how it works.

7.00.623 = base
7.00.699 = sp1
7.00.842 = sp2
7.00.961 = sp3

Jorge

-----Original Message-----
From: gary cheng [mailto:[Email Address Removed] Monday, July 08, 2002 3:42 PM
To: [Email Address Removed] SQL Version



Hi there, how can I tell the SQL server Service Pack version? It only
displays the product version including the subversion at the Enterprise
Manger. Many thanks. -Gary


_________________________________________________________________
Join the world's largest e-mail service with MSN Hotmail.
http://www.hotmail.com


---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] mail is to be used for Bank business purposes only. Confidential
information should not be sent via email as there is no expectation of
privacy or integrity of the message through the internet.


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This email message has been scanned for the presence of
computer viruses.

Chevy Chase Bank
**********************************************************************
MS Sql Server LazyDBA home page