locked
audit RRS feed

  • 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

    Tuesday, September 11, 2012 1:05 PM

Answers

All replies

  • 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:

     

    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.

    Tuesday, September 11, 2012 1:19 PM
  • is there any other solution on my proublem please suggest me.


    subu

    Wednesday, September 12, 2012 10:14 AM
  • 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

    • Marked as answer by Shulei Chen Wednesday, September 19, 2012 8:22 AM
    Wednesday, September 12, 2012 10:17 AM