I have tried that script (http://support.microsoft.com/kb/246133) in SQL2005, but I was getting the below error:

Msg 208, Level 16, State 1, Procedure sp_help_revlogin, Line 12

Invalid object name 'master..sysxlogins'.

For one of the client we had business objects 5.1.7 and Web Intelligence 2.7.4 as well as SQL Server 7.0 SP4+hotfixes (7.00.1063) installed on the same server (HP Blade Server)....

I did check their website, even downloaded trial copy of the Gupta SQL Base 9.0. Still couldn't figureout much. Now its time to read the scary manual. 🙂

Thanks though.

billkrohe: Did it resolve your problem?

We have few on WS2003 as well. EVerything fine so far.

As Dave mentioned SQL 2K SP3+ will work on WS2003.

I completely agree with Frank on this. We should not make frequent updates to any system tables. This is what been recommended by Microsoft. The reason being Microsoft can add...

I completely agree with Frank on this. We should not make frequent updates.

If I am not worng, I did modify like this to resolve one of my problem, when my primary server crashed and we moved to contingency server.

But could not remember!!!...

Thanks for your quick reply!!!

For some of my servers, I take differential Backup every hour, then copy this to remote machine using the below job:

Job: Diffrential Backup of All databases & COPY

STEP 1: Diffrential...

Don,

Thanks much for the article.

But my problem is, how I do I know which client is having bad connection among all the thousands of connections I am receiving from...

All I could get is "invalid buffer received from client"

There is a shortway of migrating SQL Server 6.5 from one server to another server. make sure both the servers has same service pack and in same directories. Then stop...

Sorry for not checking this thread early!!! (First time when I tried to type and did almost 15 lines, then when I hit the submit button, blank window came in.....

I agree with you Don. I did this morethan few times this year in SQL Server 6.5, twice in SQL 2000 SP3 this year.

Again its just sharing and it is...