I was looking inot the AUDIT LEVEL option under the security tab and i had a couple of questions.
a> Would it affect the performance of the server if you turn on the AUDIT LEVEL to failure/success/all.
b> Is this a recommended way to audit logins and/or is there any other suggestion.
c>In SQL Server books online it says that the information is recorded to the Microsoft Windows application log, the SQL Server error log, or both, depending on how you configure logging for the instance of SQL Server.
Where can you configure logging for the server?