sp_fallback_help (version 6.5)

Reports about enrollments and activations for fallback support and provides integrity checking.

Syntax

sp_fallback_help [PrimarySvrNamePattern]

where

PrimarySvrNamePattern
Specifies the name of the primary server. The default is '%'. This parameter can be any pattern appropriate for the LIKE operator.

For more information about the LIKE operator, see Wildcard Characters in the Microsoft SQL Server Transact-SQL Reference.

Remarks

This procedure provides useful information only if executed on the fallback server. If a return value is greater than 0, the integrity check detects a problem.

Permission

Only the system administrator can execute this procedure on the local primary server.

Tables Used

master.dbo.spt_fallback_usg

See Also

sp_addremotelogin sp_helplogins
sp_addserver sp_serveroption
sp_change_users_login