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:> Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
