This is SQL Server 7.0 TRM : Service Pack 2. The SQL Server version numbers for SQL7 are below :
7.00.623 Original SQL Server 7.0 or MSDE 1.0 release 7.00.699 SQL Server with SP1 7.00.842 SQL Server with SP2 7.00.961 SQL Server with SP3 7.00.1063 SQL Server with SP4 HTH Neil -----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
