Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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

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

Use the MsxDefect Method. For more information, see SQL Server Management Objects (SMO).

Arrow icon used with Back to Top link [Top]

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.