NATHAN,
you have SP2 http://support.microsoft.com/support/servicepacks/SQL/7.0/sp4ReadMe.asp @@VERSION SQL Server Version 7.00.623 Original SQL Server 7.0 or MSDE 1.0 release 7.00.699 Database Components SP1 7.00.842 Database Components SP2 7.00.961 Database Components SP3 7.00.1063 Database Components SP4 Monday, September 15, 2003, 6:42:51 PM, you wrote: NATHAN> How can I tell what version and service pack my SQL server is on? NATHAN> Select @@version yields: NATHAN> Microsoft SQL Server 7.00 - 7.00.842 (Intel X86) NATHAN> Mar 2 2000 06:49:37 NATHAN> Copyright (c) 1988-1998 Microsoft Corporation NATHAN> Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 6) NATHAN> (1 row(s) affected) NATHAN> No service pack info. Help|Abount in Query Manager only reports its own NATHAN> version correct? NATHAN> Thanks. NATHAN> -Nate NATHAN> Nathan Smith McKee, Voorhees & Sease, P.L.C. 515.288.3667 NATHAN> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:> This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
