Export (0) Print
Expand All

Defect a Target Server from a Master Server

This topic describes how to defect a target server from a master server in SQL Server 2014 by using SQL Server Management Studio, Transact-SQL, or SQL Server Management Objects (SMO). Run this procedure from the target server.

In This Topic

Security

Permissions

To execute this stored procedure, a user must be a member of the sysadmin fixed server role.

To defect a target server from a master server

  1. In Object Explorer, expand a server that is configured as a target server.

  2. Right-click SQL Server Agent, point to Multi Server Administration, and then click Defect.

  3. Click Yes to confirm that you want to defect this target server from a master server.

Arrow icon used with Back to Top link [Top]

To defect a target server from a master server

  1. Connect to the Database Engine.

  2. From the Standard bar, click New Query.

  3. Copy and paste the following example into the query window and click Execute.

sp_msx_defect ;

For more information, see sp_msx_defect (Transact-SQL).

Community Additions

ADD
Show:
© 2014 Microsoft