Thanks all for the response...much appreciated

Great article!

Thanks

If there is someone you can ask that has 'sa' authority have them set Trace Flag 1204 on? This will right the deadlock information to the SQL Server Error Log and then you...

Although lengthy this should help you out.

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx

Be sure that the ID that the SQL Server Agent is using has permissions on the network share.

As I understand your question, you want to know how to get rid of "orphaned connections" on a regular basis. You can look at the sp_who sp and see...

Hi Jason -

Yep, he has SP3 on his PC.

Thanks for the response,

Jim

Shas3 -

Thanks for the reply, I took a look at what you suggested and the Show System databases and Objects is checked. The user cannot even see the system...

thanks for the reply, we are all set now...this was a new sql 2k server that did not have the latest sp...thanks again!