audit. RRS feed

  • Question

  • Hi Team,

    we are doing some SQL Auditing in SQL SERVEr 2008 R2

    What i m looking is By Server, By Instance, i will need all of the groups and all of the standard ID logins.

    and i dot want andy service accounts.

    i want all logins and groups in a instance in sql server 2008 R2
    can you please provide script  for this
    i can use sp_help logins, sys.syslogins, it is correct for to get all logins or not.
    for groups what should i do.



    • Edited by subu999 Saturday, April 14, 2012 2:27 AM
    Friday, April 13, 2012 2:12 PM

All replies