How can you disable a linked server in SQL Server

How can you disable a linked server in SQL Server?

  • Disable data access
  • EXEC sp_serveroption @server = 'linked_server_name'
          ,@optname =  'data access'
          ,@optvalue =  'false'
  • Enable data access
  • EXEC sp_serveroption @server = 'linked_server_name'
          ,@optname =  'data access'
          ,@optvalue =  'true'