sp_msx_defect (Transact-SQL)
Applies to: SQL Server
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 the documentation for Microsoft Windows.
Transact-SQL syntax conventions
Syntax
sp_msx_defect [@forced_defection =] forced_defection
Arguments
[ @forced_defection = ] forced_defection
Specifies whether or not to force the defection to occur if the Master SQLServerAgent has been permanently lost due to an irreversibly corrupt msdb database, or no msdb database backup. forced_defectionis bit, with a default of 0, which indicates that no forced defection should occur. A value of 1 forces defection.
After forcing a defection by executing sp_msx_defect, a member of the sysadmin fixed server role at the Master SQLServerAgent must run the following command to complete the defection:
EXECUTE msdb.dbo.sp_delete_targetserver @server_name = 'tsx-server', @post_defection = 0;
Return Code Values
0 (success) or 1 (failure)
Result Sets
None
Remarks
When sp_msx_defect properly completes, a message is returned.
Permissions
To execute this stored procedure, a user must be a member of the sysadmin fixed server role.
See Also
sp_msx_enlist (Transact-SQL)
System Stored Procedures (Transact-SQL)
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om