Defect a Target Server from a Master Server

This topic describes how to defect a target server from a master server in SQL Server 2012 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.

Arrow icon used with Back to Top link [Top]

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. For more information, see SQL Server Management Objects (SMO).

Arrow icon used with Back to Top link [Top]

See Also

Concepts

Create a Multiserver Environment

Automated Administration Across an Enterprise

Defect Multiple Target Servers from a Master Server