I have this program installed on my computer which is called Hotfix Check It's a commandline app that retrieves an xml file from a microsoft server stating all current hotfixes & service packs availible and then the app will examine your pc stating the Q number for each missing Hotfix or Service Pack.
it works really great, only you have to manually install each hotfix. so if you have a fresh machine, it will take some time. But it least it gives you detailed info on "up-to-dateness" of your system. i just don't know where it can be downloaded. Perhaps you should search the MS site. Or, if you can't find it, and there are more people interested, i will put it only somewhere. regards remie bolte ----- Original Message ----- From: "Ben Timby" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Wednesday, October 09, 2002 7:15 AM 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. > > Ben Timby > Webexcellence > PH: 317.423.3548 x23 > TF: 800.808.6332 x23 > FX: 317.423.8735 > [EMAIL PROTECTED] > www.webexc.com > > > --- > You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] > To unsubscribe send a blank email to %%email.unsub%% > --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
