Results 1 to 2 of 2

Thread: List of users from different dbs

  1. #1
    Join Date
    Jan 2007
    Posts
    36

    List of users from different dbs

    I am trying to get list of users on different dbs located on different servers.Currently i get them manualy by going on each db and copy the users to excel sheet.I tried to use sysusers, but i needed status of their account, created . Is there any easy way where i can pull list of users from all dbs from at once.I also need to exclude dbo accounts ans sa accounts if possible

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Try sp_helplogins.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •