Wednesday, March 7, 2012

managing linked server config

Once I added a linked server on MSSQL how can I remove the linked server, or change its configuration?

tks

You could use either T-SQL or management studio to remove the linkedserver.

Look at sp_dropserver.

From management studio, under server objects -> linkedservers you can see the linkedserver you created.

No comments:

Post a Comment