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