Home Forums SQL Server 2005 Administering How to sync users and logins in SQL2005 after restore RE: How to sync users and logins in SQL2005 after restore

  • Why don't you just generate a script on the SQL2000 server that drops/recreates all the Windows users in each database, and then run this script against the 2005 server? Assuming all the logins already exist in the master database this should remap them all (unless I'm misunderstanding something?)