Auto Fix Query for DCL User - Sanchay Post

Query for Auto fix SQL User

• Copy the below query and paste the same into SQL Query Analyzer. 
• Select the database(i.e BPRO) / Use Query to select the DB. then execute below query.
• Next change DB name as BPLOG then Execute below query. The same procedure may apply for the database like POST, SOSB, SIGN and MDE

Auto Fix Query for DCL User
EXEC sp_change_users_login 'Auto_Fix', 'DCL'

(OR ) Follow these steps

1. Open management studio. Right click on mde database. Rename as offline.
2. Open DB analyzer > DB utilities > Update to SQL 2005. Select database offline and update.
3. Re name offline database as MDE management studio.

Tool for Fix DCL User except MDE database

Try DCL Fix Using Tool developed by PoTools