Home Forums SQL Server 2008 T-SQL (SS2K8) Execute a remote SP into a local temp table RE: Execute a remote SP into a local temp table

  • January 10, 2013 at 7:22 am

    #1575785

    Sorted, as I'm only using the Linked Server for this activity I've configured it to ignore remote proc transactions.

    EXEC master.dbo.sp_serveroption @server=N'XX.XXX.XX.XX', @optname=N'remote proc transaction promotion', @optvalue=N'false'