Works perfect! Thanks your help SpringTownDBA.

Works great thank you RBarryYoung!

Hi Phil,

I have log shipping via having a linked server and stored procedures executing remotely. But as you say, it’s unreliable!

I’d be interested to hear in a little more...

Fantastic!! Thank you for your help it worked from Query Analyzer... Now I'll just have to get it working SQL Server Agent / Jobs.

Warwick.

Thank you for the feedback Guys.

Below is the copy of the stored procedure I’m trying to run on the remote...

Thanks I tried that but I get the error message below:-

Server: Msg 7357, Level 16, State 2, Line 2

Could not process object 'exec pubs..wf_test_sp'. The OLE DB provider 'SQLOLEDB' indicates...

Thank you for your reply!

Do you know if there is such a thing as compatible collations?

Thanks Warwick.