OK I realized that I was simply wrong about Herts Chen's solution. It DOES work just as he explained. Here is my new code:

USE tempdb

GO

CREATE PROC SP_DoSomething AS BEGIN

SET NOCOUNT ON

DECLARE...

Thanks for the tip Brian! I had messed around with that earlier and even though I could use that to get the command that is executing, it doesn't return the...

It's not technically impossible but is probably not recommended in most situations. Here is a way to do it (without the table parameter actually working). There is also a way...

Ahh, figured it out. You can do it by nesting the EXECs

EXEC ('SET ANSI_NULLS ON EXEC(''' + @sql + ''')')

cool.

Actually, I found that in the MSDTC security configuration dialog from the component services, if I set the "Transaction Manager Communication" authentication from "Mutual Authentication Required" to "Incoming Caller Authentication...

I am experiencing this as well referencing a stored procedure on a linked server from a trigger. Unfortunately, the suggestions here didn't help me either. Were you ever able to...