Listing database users for all databases on a server

  • Hi All

    I am posting on the newbies forum as I am sure i am overly struggling with something that many DBAs do in their sleep all the time!

    I want to delete a login I have on my server as I am fairly sure the database it was associated with has been deleted. When I look at the login properties there are no users mapped to this login, does that mean that I can just go ahead and delete the login without fear that it might own a schema or leave an orphaned user?

    Sorry for being so dumb but I have done a search and can't be quite sure that I can just go ahead and delete this user.

    Many thanks!

  • I believe sp_helplogins is what you're looking for to get your answer.

    BOL: ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/f9ad3767-5b9f-420d-8922-b637811404f7.htm

    😀

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply