416 Byte hinzugefügt,
10:18, 13. Jan. 2016 == Fixing Orphaned Users ==
=== Report ueber Orphaned Users ===
<pre>EXEC sp_change_users_login 'REPORT'
UserName UserSID
-------- -----------------------------------
user1 0xB675848D3CC91D56932769131728CF1E
user2 0xC675848D3CC91D56932769131728CF1F
user3 0xD675848D3CC91D56932769131728CF1A</pre>
=== Reconnecting a User DB User<->SQL Login ===
EXEC sp_change_users_login 'UPDATE_ONE','user1','user1'