Removes the current server from multiserver operations.
Caution sp_msx_defect edits the registry. Manual editing of the registry is not recommended because inappropriate or incorrect changes can cause serious configuration problems for your system. Therefore, only experienced users should use the Registry Editor program to edit the registry. For more information, see your Microsoft® Windows NT® or Microsoft Windows® 95 documentation.
sp_msx_defect [@forced_defection =] forced_defection
Note After forcing a defection by executing sp_msx_defect, a member of the sysadmin fixed server role at the Master SQL Server Agent must run the following command to complete the defection:
EXECUTE msdb.dbo.sp_delete_targetserver @server_name = 'tsx-server', @post_defection = 0
0 (success) or 1 (failure)
None
When sp_msx_defect properly completes, a message is returned:
Server defected from MSX ''. n Job(s) deleted.
Only members of the sysadmin fixed server role can execute sp_msx_defect.
sp_msx_enlist | System Stored Procedures |