BUG: Transfer Login Task Is Slow with a Large Number of Logins (311351)

The information in this article applies to:

Microsoft SQL Server 2000 (all editions)

This article was previously published under Q311351

BUG #: 355746 (SHILOH_BUGS)

SYMPTOMS

The Transfer Logins Task in Data Transformation Services (DTS) and the Copy Database Wizard (CDW) with the option to copy Only logins used by the selected databases in which there are a large number of logins may result in slow performance.

CAUSE

SQL Profiler shows that if you select the Only logins used by the selected databases option, the sp_MSloginmappings stored procedure executes for each login.

WORKAROUND

To work around this problem, use the sp_help_revlogin stored procedure script to transfer the logins.

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

246133 HOW TO: Transfer Logins and Passwords Between Instances of SQL Server

STATUS

Microsoft has confirmed that this is a problem in SQL Server 2000.

Modification Type:	Major	Last Reviewed:	12/3/2003
Keywords:	kbbug kbpending KB311351