| Tibor Karaszi 2006-03-10, 11:23 am |
| A login isn't created "with" a database, so SQL Server cannot know if you added some login
particularly for that login to be able to access database A or database B. You might be able to
figure that your by the default database for the login, assuming you change the default database for
the logins.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/
"George Schneider" < georgedschneider@new
s.postalias> wrote in message
news:83AE854C-6642-43F2-9F93- 124C9BFBF854@microso
ft.com...
> When I was moving some databses over to a new server I used the copy databse
> wizard which created the neccessary logins in the sysxlogins table on the
> master databse. Some of the databases I decided I no longer needed so I
> delted the db's. However the login associated with these still exists in
> sysxlogins and no where else. Is there a way to delete these logins to clean
> things up?
|