How can you disable a linked server in SQL Server?
EXEC sp_serveroption @server = 'linked_server_name'
,@optname = 'data access'
,@optvalue = 'false'
EXEC sp_serveroption @server = 'linked_server_name'
,@optname = 'data access'
,@optvalue = 'true'