MS SQL Server - Where to search for users added to the server

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Where to search for users added to the server

neha via SQLMonster.com

2006-02-17, 7:23 am

I added some 5k users to the sql server using the enterprise manager and want
to delete them now. I deleted all the users in the master database from the
enterprise manager but realised that the users were still present on the
server. I then deleted all the entries (except the builtin admin) from the
sysxlogins table. Is there anyother table where these entries are made? Or
should the entries be completely erased from my system now?
Is there a way of finding out how many users are present in the server?

--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...server/200602/1

Sponsored Links