SQL audit login settings

I need a TSQL statement that finds the audit login properties setting is for SQL 2000 and 2005+ servers (be it none, failed logins only, successful logins only or Both ).

Can anyone help?
Who is Participating?
Tony303Connect With a Mentor Commented:
Is this a help on the way.

I think SQL 2000 and SQL2005 will reside in a different folder structure, if my memory serves me correctly, so you'll have to do a couple of SQL Statements.

barnescoAuthor Commented:
That's perfect. Thank you.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.