Derek -

Thanks for the reply.  Trust me, this server has been rebooted several times since encountering the problem.  The only time it "worked" was after I set the 2 SQL...

SQLBill -

Checked the dependencies and SQLSeverAgent is dependant on MSSQLServer.  I might give it a try with MSSQLServer set to auto and Agent set to manual just to see what...

I did try one experiment today.  (Nothing like "experimenting" on a production box!!! )  Anyhow, what I did was changed the MSSQLSERVER and...

Yes.  Definately had a stong password for the SA account prior to the issue we're experiencing.  We have anti-virus software with the latest definitions installed on this server (this was...

I applied sp3a.  Unfortunately the same problem still exists - after logging on to the server the desktop is slow to load and when it does SS2K is still hung...

sswords -

Our server group has been reviewing the logs and they're not seeing anything out of the ordinary.

They tried to kill the MSSQLSERVER process but couldn't until DTC was disabled. ...

SQLBill -

Thanks for the reply.  I did as you said and here's what returns:

8.00.194    RTM

I thought SP3a was applied for SQL Server.  However, a rather unreliable vendor did this for...

I'm defining duplicate as a record/row that is entirely the same between the two import tables.

For example, if our primary server is doing all the calling it will record things...

So close.  So far.  So frustrating!  LOL

Thank you for your help.  That did the trick.

Thanks again!

Brian

Works like a charm and makes coding more simple!

Thanks!

Brian