Tuesday 27 January 2009

orpaned SQLServer users

After database refreshes, you can run something like below:

sp_change_users_login @action='report'

sp_change_users_login @action='update_one', @usernamepattern='xedefault', @loginname='xedefault'

No comments: