Thank-you to all who replied. I thought I was really missing something (other than SP 4)
-Nate -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, September 15, 2003 10:48 AM To: SQL Subject: RE: SQL Server 7 version and service pack oh and yes, Query Analyser only reports on its own version and/or build number. -----Original Message----- From: NATHAN C. SMITH [mailto:[EMAIL PROTECTED] Sent: 15 September 2003 16:43 To: SQL Subject: SQL Server 7 version and service pack How can I tell what version and service pack my SQL server is on? Select @@version yields: Microsoft SQL Server 7.00 - 7.00.842 (Intel X86) Mar 2 2000 06:49:37 Copyright (c) 1988-1998 Microsoft Corporation Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 6) (1 row(s) affected) No service pack info. Help|Abount in Query Manager only reports its own version correct? Thanks. -Nate Nathan Smith McKee, Voorhees & Sease, P.L.C. 515.288.3667 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:6 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:> Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
