About Us
SSWUG Articles
Articles
FAQ
Administration
Backup/Restore
Connectivity
Development
General
Installation
OLAP
Replication
Transfer/move
Trouble
SQL 6.5
Scripts
Tips
Test Exams
Advertise
Download
History
Search
Traffic
Related Links
Add to Favorites
How can I fix lost users after attaching database with sp_attach_db?
Answer:
You can use
sp_change_users_login
system stored procedure with the Auto_Fix action value.
For more details, see
sp_change_users_login
in SQL Server Books Online.
Visit
The SQL Server Worldwide User's Group
for all the latest news and information about
SQL Server, Oracle, DB2 and XML for developers and administrators
.
(c) 1997, 2005 Bits on the Wire, Inc