andy-uq/Fix user.sql

Created August 15, 2014 02:34

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/andy-uq/22ac3c9480d409779869.js"></script>
Save andy-uq/22ac3c9480d409779869 to your computer and use it in GitHub Desktop.

Download ZIP

Repair SQL orphaned users

Raw

Fix user.sql

EXEC sp_change_users_login 'Auto_Fix', 'user'

Raw

EXEC sp_change_users_login 'Report'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment