Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
audit.

Locked audit.

Locked

  • Friday, April 13, 2012 2:12 PM
     
     
    Sign In to Vote
    0

    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.

    Tx

    subu


    • Edited by subu999 Saturday, April 14, 2012 2:27 AM
    •  
       

    All Replies

    • Saturday, April 14, 2012 2:28 AM
       
       
      Sign In to Vote
      0

      HI Team,

      Till now i did not get any reply for this could you people please respond to this.

      subu

         
      • Monday, April 16, 2012 2:30 PM
        Moderator
         
         
        Sign In to Vote
        0

        You have cross posted similar question is 3 places. I have merged other two and I'm going to lock this one.

        More people has responded to you in the below thread, please continue your discussion there

        http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/f6e724f2-7bbe-478d-bd93-f97f4f426248/#366fe721-3ea0-4a66-a1de-3e0af906c17a

        Please don't cross post in mulitple categories. To get proper response post your question in correct category one time, I'm sure people are here to help you. Thanks for understanding

        Mark as ANSWER if I helped you today :-)