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

• Before you begin:

  Security

• To defect a target server, using:

  SQL Server Management Studio

  Transact-SQL

  SMO

Before You Begin

Security

Permissions

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

Using SQL Server Management Studio

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.

Using Transact-SQL

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).

Using SQL Server Management Objects (SMO)

Use the MsxDefect Method.

See Also

Create a Multiserver Environment
Automated Administration Across an Enterprise
Defect Multiple Target Servers from a Master Server