Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Ctrl-alt-geek

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, 339 reads

Posted in Ctrl-alt-geek on 21 March 2012