It runs every 15 minutes.

Your correct, that was the first choice. Looking at the fact we would have millions of records we were trying to think out of the box to see if...

Thank you very much for your insight - I appreciate it!

ah, my mistake, thank you. So I'm assuming there is a timeout setting in SQL Server then for connections that were dropped to clean them up?

The transactions are handled by the client side.

That is set on the server for 600 seconds for "remote queries" under the Server Connections. So then the connection is left sort of in an "orphaned" state, pardon...

We have many legacy systems that span databases with SSN or other unique sensitive info about someone. Developers and testers needed a way to compare a paticular person and...

Thanks to you both!

RSCI? I'm not mentally processing the abbreviation

Perfect, they are. That makes things more clear now. I was tracking down why replication was causing some blocking on index objects that were not related to one...

VERY NICE!

So according to your 3rd point below on your BLOG if those three update statements are seperate clients on seperate tables not related to each other they could be...

Interesting, so I may not be crazy! So, where is the autocommit mode configured, replication is configured with all the default settings except a few agent properties to poll...

I appreciate the post. I thought I had seen only one commit per sync in the profiler trace making me think that each sync was appling all the unique...

Backups only occur early in the morning and the largest database is only a few GB in size. There are about 7 databases on the server.

Intersting I don't see any more messages that the working set is being trimmed today, the available MB is 13000, but the page file % usage is still 100%. ...

No, on this server it is lightly used, no large copies of files.

Sorry, forgot to mention it is Standard Edition.