audit

Question

Hi Team,

I m working with sql audit i have enable sql audit it was saving in file format only

i want that out put in table formart could you any body please suggest me.

Tx

---

subu

Answer 1

Hi Sabu,

I suggest you to use EVENT NOTIFICATIONS instead. Check out my following article in which I discussed the several ways to audit securty:

 

Different ways to audit SQL Server security

---

Regards,

Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)

http://basitaalishan.com

Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Answer 2

is there any other solution on my proublem please suggest me.

---

subu

Answer 3

try if this works, you can directly fire queries instead of importing them to a database, check this lick

http://support.microsoft.com/kb/270599

---

Ramesh Babu Vavilla MCTS,MSBI