How To Remove A Linked Server In SQL Server

Sometimes you may wish to remove a linked server so that data access is restricted to locally running queries. To remove a linked server, run the following SQL query:

sp_dropserver ServerName

This will remove the linked SQL server from the sys.servers database table.

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)

Leave a comment

Your email address will not be published. Required fields are marked *