September 11, 2009 at 9:31 pm
I have 2 records in a database in security that are suddenly missing the login name. Is there a way to fix this?
September 11, 2009 at 11:52 pm
Welcome...
I guess you'll have to post some more details if you want us to help: What is your table structure, how is the security column being populated, how many records are OK compared to the 2 bad records, etc...
September 12, 2009 at 7:53 am
If the problem relates to orphaned database users (where a login of the same name exists but the mapping is broken), you can fix this with ALTER USER
September 14, 2009 at 4:50 am
Paul White (9/12/2009)
If the problem relates to orphaned database users (where a login of the same name exists but the mapping is broken), you can fix this with ALTER USER
the older way is to run :
use [databasename]
go
sp_change_users_login 'report'
which will report the database users without a valid login.
like Paul has mentioned you can use the ALTER USER command as well.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 14, 2009 at 5:02 am
Yes, I'm trying to wean myself off sp_change_users_login since it is now deprecated in favour of ALTER USER :w00t:
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply