SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in


Matt Bowler is a DBA at Trade Me, 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, 800 reads

Posted in Ctrl-alt-geek on 21 March 2012