Microsoft KB Archive/311351

= BUG: Transfer Login Task Is Slow with a Large Number of Logins =

Article ID: 311351

Article Last Modified on 12/3/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



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.

Additional query words: security logon

Keywords: kbbug kbpending KB311351

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.