June 27, 2005 at 8:44 am
(the person who designed the app that this database uses is used to mysql)
That said, I'm stuck with the only user of the db being orphaned, and so I cannot drop the login or the user. I've tried to drop and restore the database and then the user, but that doesn't correct the issue.
Running sp_changeobjectowner throws back an error that the object is invalid or the process cannot be applied to the object
How can I 'resolve the orphaned user'?
June 27, 2005 at 8:46 am
Are you using Enterprise Manager or QA and TSQL? Enterprise Manager sometimes doesn't work, but sp_dropuser should.
June 27, 2005 at 8:49 am
Have you tried researching sp_change_users_login with AUTO_FIX?
Good Hunting!
AJ Ahrens
webmaster@kritter.net
June 27, 2005 at 9:21 am
I generally use QA.
sp_change_users_login worked, thanks!
(I knew there was a script to do it, just was looking the wrong way for it)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply