Results 1 to 2 of 2

Thread: List of users on sql server on different servers

  1. 05-01-2007, 02:53 PM #1
    indyandumi
    indyandumi is offline Registered User
    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?????
    Reply With Quote Reply With Quote
  2. 05-02-2007, 08:20 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Run sp_helplogins on each server.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules