This is what I found and enlighten me if anyone has more info.. thanks..

http://doc.ddart.net/mssql/sql70/bckwd.htm

Even when the database compatibility level is set to 60 or 65, applications gain almost...

Thanks very much for the info...

Are you sure MS has stop supporting SQL 6.5 since 1998? I have read in a MS Tech magazine where the author quote as saying MS Support policy is...

Thanks for the DBCC command. I ran it but does not report any error. DBCC checkdb and alloc but find no error. Probably some bug in SQL....

Thanks for the info. We have tried the dbcc check and no errors were reported. On Micorsoft's knowledge base site, they mention that this could be due to a...

Does the SP/pathes apply to the OLAP server too? If not, where can I get some info on the OLAP SP and hotfixes? thanks again..

Thanks Allen.. Another question, I notice the posting on http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37 that latest build is 8.00.873 but I can't seem to find the link to download the patch. ...

As far as applying SP, when you apply a SP to the SQL Server do you have to apply it to the Client too? thanks..

Thanks.. But SQL2k as I know latest build is 8.00.850. I think this might be a private fix so it not out there..

Thanks for the script but I were looking more of an alert from MS. But the irony here is I work w/ MS products but MS site is block...

Very interesting site.. thanks..

It's configure to monitor all servers in a domain that match a criteria such as:

(AttributeValue(SQL Server 2000))

In this way, all the SQL servers will have an agent install to...

Thanks for the info and confirming my assumption.

One of the db did failed to backup so I guess this is what caused the old backup files not to be deleted. But it seem strange that even...

One of the db did failed to backup so I guess this is what caused the old backup files not to be deleted. But it seem strange that even...