Archives: March 2012
The other day I was asked to restore a production database into a development environment and then check the database permissions. So after restoring the database I ran
use 'database name' exec sp_change_users_login 'report'
to see if there were any orphaned users. This came back clean so I informed the… Read more