Microsoft KB Archive/311351

From BetaArchive Wiki
Knowledge Base


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