Following URL gives you hotfixes for SQL Server 7 www.microsoft.com/technet/security/http://www.microsoft.com/technet/treeview /default.asp?url=/technet/security/current.asp?productid=29&servicepackid=0& submit1=go&isie=yes
The following URL gives you SQL Server versions by Service Pack http://support.microsoft.com/default.aspx?scid=kb;en-us;Q321185#3 7.00.699 is SQL Server 7.0 Service Pack 1 (with no hotfixes) 7.00.1063 is SQL Server 7.0 Service Pack 4 (with no hotfixes) However, if you had installed the recent roll-up patch, then you'd be at 7.00.1077 now: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q327068&sd=tech Cheers Ken ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ From: "Ben Timby" <[EMAIL PROTECTED]> Subject: SQL server patch history : Does anyone know of a site that lists all hotfixes for MS SQL server, : their dates, and notes? : : I would like to know when bugs were fixed, for instance, the following : query only works on the first server: : select cast((select MAX(name) from sysobjects where type='u' and name < : 'X' ) as int); : : Servers: : Microsoft SQL Server 7.00 - 7.00.699 (Intel X86) May 21 1999 14:08:18 : Copyright (c) 1988-1998 Microsoft Corporation Standard Edition on : Windows NT 4.0 (Build 1381: Service Pack 6) : Microsoft SQL Server 7.00 - 7.00.1063 (Intel X86) Apr 9 2002 14:18:16 : Copyright (c) 1988-2002 Microsoft Corporation Standard Edition on : Windows NT 5.0 (Build 2195: Service Pack 3) : : And I would like to know why. --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
