Post reply

Audit Trail

  • September 18, 2006 at 9:14 am

    #116697

    Hi,

    How can I maintain Audit trail data for one year?

    Thanks in advance.

    rs.

  • September 18, 2006 at 9:41 am

    #661059

    What do you need to audit exactly???

     

    Data modifications, data access, historical data??

  • September 18, 2006 at 9:52 am

    #661063

    Hi, Thanks for quick response.

    4-5 months back management did sql server security check, they ran the following query

    select * from ::fn_trace_getinfo('0')

    select

    * from ::fn_trace_geteventinfo('#')

    select

    * from ::fn_trace_getinfo('0') where property=1 and (cast(value as int) &4) != 4

    I am not aware of these, and also they said want to keep Audit trail data for one year, I expect they are SQL Server logs under management in management studio. Sorry I didn't explain properly.

     

  • September 18, 2006 at 9:57 am

    #661064

    I am not very familiar with those system functions.

     

    Do they want you to run those like every day and keep the results in a history table and have that available for reporting needs?  If not, then what do they want you to do?

  • September 18, 2006 at 10:02 am

    #661069

    Hi, I think still its not clear for me, they are going to run them soon, I want to prepare for that.

    Thanks,

     

  • September 18, 2006 at 10:36 am

    #661076

    Ask them to clarify what they need, then we'll be able to guide you on this... and do it only once .

    Make sure they tell you what they intend to do with that data afterwards too.

     

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply