Home Forums SQL Server 2005 Development Table variable as Output Parameter RE: Table variable as Output Parameter
marcjell
Old Hand
Points: 349
More actions
August 28, 2011 at 1:22 pm
#1374317
Instead of doing a self-referencing linked server, you can directly call sp_ExecuteSQL within the context of any database using three-part naming:
[mydatabase].sys.sp_ExecuteSQL (N'...')