Subscribe to this blog
Ctrl-alt-geek
Matt Bowler is a DBA at SQL Services, and teaches database design and administration courses at the local institute of technology. A recent but avid discoverer of SQL Server, Matt is a regular contributor to forums at MSDN, Experts Exchange and SSC and he blogs at mattsql.wordpress.com.
Archives: March 2012
Comparing users and role memberships between two databases
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
0 comments, 162 reads
Posted in Ctrl-alt-geek on 21 March 2012