XML using T-SQL would be less of a pain if it did allow variables

I've got a similar problem.  I had several jobs scheduled to copy databases from a live instance to a development instance both running on the same server.  On installing SP2, the jobs...