Never been to TextSnippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)

Fix orphaned users in MSSQL (See related posts)

Thanks to CodeProject for this code

Run this in the Query Analyzer (make sure the right database is selected first).

sp_change_users_login 'auto_fix', 'UserName'
to users sql mssql microsoft data transact orphan orphaned user restore restoration restoring by chrelad on Tue Dec 11 22:25:22 +0000 2007

You need to create an account or log in to post comments to this site.


Related Posts