SQL Server Performance Forum – Threads Archive

How to setup Audit ?

Hi there, Just wondering if there are any document on how to setup auditing for SQL Server (2000 & 7) using sql profiler and view the audit log as books online is not of great help. Thank you.

---

Hi ya, what kind of auditing are you hoping to set up? Login attempts can be audited within SQL Server itself, anything more detailed would require SQL Profiler. I’ve not come across any specific documents talking about auditing with SQL Profiler though… I’m sure Satya will add some links from his extensive knowledge base database Cheers
Twan

---

Thanks Twan. Review information from this Technethttp://www.microsoft.com/technet/tr…/technet/security/prodtech/dbsql/sql2kaud.asp link about Auditing. And using <Advanced Search> link in this website returned this informationhttp://search.atomz.com/search/?sp-…0&sp-end-year=&sp-x=any&sp-c=10&sp-m=1&sp-s=0 and its upto you to refer thru. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

---

Thanks Satya & Twan

---

Another help: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_id_com_admn2.asp Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell

---

]]>