If you are using SQL Server 2000 or later you can use the ALTER DATABASE command. USE the database and then issue ALTER DATABASE SET SINGLE_USER. Then USE another...

I am looking into turning this option off. I am not sure why they have it turned on in the first place. In the meantime I am trying to track...

True, I should check for sp_dboption as well. Good point.

Yes, it could very well be coming from another server. I've combed through most of my servers and haven't found...

Good idea. I can add the RPC:Completed. And you are correct, it it is a stored procedure doing this I will not see it in the trace. I guess I...

If you query sysjobsteps in msdb you should get the dbname that is being used for that step (if any).

George

Thanks for the reply. Unfortunately I don't have an .ini file. By default it uses xml that is stored in the registry. And the directions say not to fiddle with...

Thanks for the quick reply. I've scoured the web for days trying to find an answer to this and I have run across this thread and others with the same...

I think I've figured this out. I put the steps required in the transaction inside of a Sequence Container which is inside of the ForEach Loop container. I removed the...

Dan,

Thanks for the information! I really appreciate it.

George

I have found that using Server2 and Transfer2 have helped the issue.

But I have a new problem. I get an "invalid object" error on a udf. The app is...

Thanks Brian. Sounds like it might be exactly what I am looking for!

Thank you. Very good thread for this topic. Thanks so much.

George

Problem is this is a productin loan system. On top of that there are so many tables with blobs that I wouldn't know where to start! Was just hoping I...

I typically have to apply patches and hotfixes to both nodes on a cluster. Thought this was required.

Is there a way for me to verify that this is the problem or do I just need to go by the symptoms that I am seeing?

Thanks again,

George