I was sure I knew the answer to this, but I do believe I am too influenced by Developing T-SQL and PL/SQL at the same time. This information is also available at

http://msdn.microsoft.com/en-us/library/ms188332.aspx.

Execute a pass-through command against a linked server

{ EXEC | EXECUTE }

( { @string_variable | [ N ] 'command_string [ ? ] ' } [ + ...n ]

[ { , { value | @variable [ OUTPUT ] } } [ ...n ] ]

)

[ AS { LOGIN | USER } = ' name ' ]

[ AT linked_server_name ]

I should have gone to the books online and verified my answer. This was a great question.

Thanks,

RickMan 😀