New answers tagged linked-server
6
votes
Accepted
SQL Server linked server's DATA ACCESS property changes to false
The only way to change the linked server properties I know of is via system procedure sp_serveroption.
This procedure is called in the background even if you change the properties via GUI.
So you can ...
- 3,500
0
votes
Using INSERT INTO...EXEC AT linked server into temp table fails with Msg 7391
This way you can manipulate your query with parameters that you want to add and at the same time carry out the insert into by executing the EXEC AT LINKEDSERVER command.
The only drawback is that you ...
Top 50 recent answers are included