Q0004 – Discussing Execute(SQL) At LinkedServer

[Peter Jones]

One of the ways we are thinking of executing sql on remote BC Servers is as follows.

https://dzone.com/articles/discuss-executesql-at-linkedserver

 DECLARE @Script nvarchar(max) =
    N'
    <dynamic sql script>
    ';
EXECUTE (@Script) AT <linked_server_name>
INSERT <table> (columns)
EXECUTE (@Script) AT <linked server>; 

• This topic was modified 1 year, 11 months ago by Peter Jones.

Best Regards
Peter Jones

[Author]

Posts