-- local server exec sp_executesql N'select @@version' -- remote server exec tranasctional2005...sp_executesql N'select @@version'" (1 row(s) affected) Msg 7411, Level 16, State 1, Line 4 Server 'tranasctional2005' is not configured for RPC. "
Right click, Linked server Name,
Select Properties.
Select Server Options page from the menu on the left.
Set RPC Out to 'True' on the pane on the right.
No comments:
Post a Comment