New answers tagged

6 votes

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 ...
Zikato's user avatar
  • 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 ...
Pedro Alves's user avatar

Top 50 recent answers are included