September 5, 2003 at 11:33 am
I have the same user in multiple databases as the table owner. In one of the databases the login name is showing as a blank. Don't understand why or how to change. Any advice on how to fix this situation?
September 5, 2003 at 11:44 am
Was this restored? The user is in the database and the login is in master. They are linked in the database "sysusers" table. If it is blank, sp_change_users_login will help you fix this.
Steve Jones
September 5, 2003 at 12:44 pm
That did the trick - thanks. I have no idea how it could have happened, but at least our web app can log in again.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply