DATABASES » TOOL AND UTILITIES
ID #1054
Orphan users
Subject: SQL Orphaned Username Fix
If you can't assign a username to a SQL database because the username already exists. Do the following in Query Analyzer.
sp_change_users_login 'report'
This will tell you if you have orphaned users.
Use the name returned as the username below.
sp_change_users_login @action = 'update_one', @usernamepattern = 'username', @loginname = 'username'
Tags: -
Related entries: -
Last update: 2009-12-21 12:03
Author: Administrator
Revision: 1.1
TechNetSource on Facebook
