September 4, 2003 at 7:54 am
Hello, I have an orphaned user in a database we moved from a 7.0 server to a 2000. The user is actually a Windows Group. I've tried sp_dropuser N'Windows Group Name' but it says that it's not a valid user in the database. I looked at the definition for this proc, and it says it actually fires off sp_revokedbaccess. Looking at that definition in SQL Server Online books, it says that it can't be used to remove Windows Groups! So that explains it...except it doesn't explain HOW TO remove a Windows Group! Also, the user does not show up in Enterprise Manager, so I need the command line way to do this...THANKS!!!
September 4, 2003 at 8:34 am
Use sp_helpuser to see whether the user is in the database and sp_revokedbaccess 'theusernamehere' to remove it.
September 4, 2003 at 8:47 am
I read the MS write up on that proc incorrectly...you were right! sp_revokedbaccess worked. Thanks a million.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply