Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MediaPirate
Yak Posting Veteran
52 Posts |
 Posted - 2007-06-22 : 11:09:56
|
| I've got a Windows login, which I cannot drop. I have checked about everything I can think of and can't find a connection to this user. Is there a script which anyone has which will list all object referencing this users? SQL 2005 ENT x64. It's a windows domain user. |
|
|
MediaPirate
Yak Posting Veteran
52 Posts |
Posted - 2007-06-22 : 11:43:33
|
| We found the problem, the Windows login which was added to SQL was impersonating a NT Group in SQL logins. I deleted the Group, then deleted the Windows from login and recreated the group. |
 |
|
|
|
|
|
Drop Windows Login