Friday, April 13, 2012 2:12 PM
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
Saturday, April 14, 2012 2:28 AM
Till now i did not get any reply for this could you people please respond to this.
Monday, April 16, 2012 2:30 PMModerator
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
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 :-)