Export (0) Print
Expand All
Expand Minimize

sp_resolve_logins

SQL Server 2000

Resolves logins on the new primary server against logins from the former primary server.

Syntax

sp_resolve_logins [ @dest_db = ] 'dest_db'
    , [ @dest_path = ] 'dest_path'
    , [ @filename = ] 'filename'

Arguments

[@dest_db =] 'dest_db'

Is the name of the new primary database. dest_db is sysname, with no default.

[@dest_path =] dest_path

Is the path to the directory where filename is stored. dest_path is nvarchar(255), with no default.

[@filename =] filename

Is the name of the file containing a bulk copy of the syslogins table from the former primary database. filename is nvarchar(255), with no default.

Return Code Values

0 (success) or 1 (failure)

Result Sets

None

Remarks

sp_resolve_logins must be run on the instance of SQL Server marked as the new primary server (former secondary server). You must run this stored procedure from the target database.

In order to complete a log shipping role change, you must perform several steps in addition to running this procedure. For more information, see How to set up and perform a log shipping role change (Transact-SQL).

Permissions

Only members of the sysadmin fixed server role can execute sp_resolve_logins.

Examples

This example shows how to resolve logins on the new primary server against logins from the former primary server. 'db2' is the name of the new primary database. 'syslogins.dat' contains a bulk copy of the syslogins table from the former primary database and is stored in directory 'c:\bulkoutput\'.

EXEC sp_resolve_logins @dest_db = 'db2',
   @dest_path = 'c:\bulkoutput\',
   @dest_filename = 'syslogins.dat'

See Also

sp_change_monitor_role

sp_change_primary_role

sp_change_secondary_role

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft