dcsimg
Results 1 to 2 of 2

Thread: List of users on sql server on different servers

  1. #1
    Join Date
    Jan 2007
    Posts
    36

    List of users on sql server on different servers

    Hi guys this is my situation................
    ===================================
    I have three 4 SQL server database servers. And each of these servers have at least 10 databases. What i need is to be able to get the list of users with their permision infomation
    i.e Name Loginname Database access.

    Is there any way i can automate this process?????

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Run sp_helplogins on each server.

Posting Permissions

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