Ran a test after enabling TF 692 and continued to see blocking by the select against sys.dm_db_index_physical_stats, unfortunately.

Thank you for the info Jeff, I'll start doing some research on that trace flag and the changes around the Fast Inserts.

Figured out the default port for the SQL Native Client was incorrectly set.  Case closed.

Update... If I add the default port number to the end of the Data source field on node A I can get the linked server to work.  Port number is...

Were you able to adjust an index to remove the lookup?

Good point Grant....I missed that it was on 2012. :crazy:

Gotta love the new CE! Is there an index that exists on the table that you think it should be using but isn't? If you can get rid...

Haven't used tokens. I've been checking numbers using sp_replcounters on the publisher and using fn_dblog as well. I've also used the DMV's on the distributor, but it seems...

I've got 7 publishers sending to 2 different subscribers. There is a combination of push and pull subscriptions running. The distributor itself is a separate server. Currently...

I'll watch the SQL Log to see how it recovers and verify that I don't see any errors there and that it's come fully online...if not, off to backups I...

Thank you Gail! I'm going to try to get thru the business day and perform a restart tonight. At that point I'm going to fire off a tran...

Thanks for the reply! We're going to do a restart of services this evening and I'm hoping that will do that trick!

I've noticed that the schema compare can have issues with whitespace. You might be able to limit some of the issues by ignoring some of the schema compare options...

Dyn-o-mite

Out of curiosity, what is the data type for the CI? Are you using GUIDs at all?