I'll need to get permission from the client to turn on the trace, but in the meantime here is the limited information from the SQL Error Log.** Each of these line items are a single line. WYSIWYG!I should also mention this server participates in Merge Replication.
I was able to id one node by the objects identified in the image above, but can't seem to get the object info for Node 2 since it's in the "hidden" Resource DB.
Node 1 refers to a procedure in the "production" database. The procedure performs a few simple selects, an update and a call to another proc. which performs a single insert. The only functions involved on this node are getdate, isnull and convert. No triggers (other than the replication triggers) on any table involved. This proc is very straight forward, no complex queries, cursors or logic holes (loops etc.). All tables involved are small (< 10 k rows)
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE
you'll likely increase the number and quality of responses you get to your question.Jason L. Selburg