Idea 1: add WITH RECOMPILE to the proc.

Idea 2: turn the query into dynamic SQL using exec('...'), with the values of the parameters inserted into the query string.

I'm in agreement with hurcane on possible network overhead (coming from the voice of experience 🙁 )

You might try "select * into #tmp from section" instead of a straight...

Also agreed with viacoboni. Sorry jpipes, but the question was "what is the best way to fix the problem". To me, getting around a deadlock error by making a change...

Agreed with mespadoto. SQL can *backup* to any drive anywhere on the network, as long as it has proper permissions to a share on that drive. I thought this was...

Enjoyed the test, and learned a few things too. I've been working with SQL many years and there's always more to learn, that's what I love about it.

Just my 2c...

We used to have this problem as well. Another idea ... find the job that runs the merge agent (as jmadren describes), go to the Schedules tab, click New Schedule,...