Technology with opinion

Monday, November 16, 2009

Associating Users & Logins in SQL Server after Database Restore

Often times when you restore a database in SQL Server from one server to the next the Logins will become disassociated with the User a specific database.  We ran into this today and another software engineer found a good script from a guy he knows:

Executing this script should find unassociated logins and reassociate them with the users in the current database

1 comment:

Leslie Lim said...

I admired those who has able to create a blog as wonderful as this! You are truly a hard working person. Keep up the good work and keep on posting.