SQL Server/Database Auditing

bbrown
bbrown Member Posts: 3,268
edited 2010-12-09 in SQL General
Has anyone implemented SQL Audit on a system hosting NAV? if so, any issues?
There are no bugs - only undocumented features.

Comments

  • kine
    kine Member Posts: 12,562
    What you want to audit?
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • bbrown
    bbrown Member Posts: 3,268
    Undecided at this time. Could be anything for which an audit action can be defined. More of a generic question right now. Just fishing if there are any "I did this and it broke my NAV system" responses.
    There are no bugs - only undocumented features.
  • rmv_RU
    rmv_RU Member Posts: 119
    bbrown wrote:
    Undecided at this time. Could be anything for which an audit action can be defined. More of a generic question right now. Just fishing if there are any "I did this and it broke my NAV system" responses.
    Hi. My implementation is simple :).
    1. Create log table
    2. Generate SQL triggers only for ledger tables.
    You should use app_name() property to exclude Nav activity. For most Nav version app_name() is IN ('Microsoft Business Solutions-Navision client', 'Microsoft Dynamics NAV client', 'Microsoft Business Solutions-Navision', 'Microsoft Dynamics NAV','C/ODBC','C/FRONT','Navision Application Server', 'Microsoft Dynamics NAV Application Server','Navision VIP Application Server') .
    You could use 
    exec('DBCC INPUTBUFFER ('+ @spid + ')')
    statetment to log modification query
    Another useful properties are host_name() , system_user.
    Looking for part-time work.
    Nav, T-SQL.
  • bbrown
    bbrown Member Posts: 3,268
    I think you may have misunderstood my question. I'm not talking about inventing something. I'm talking about SQL Server Audit. (A feature of SQL 2008).
    There are no bugs - only undocumented features.

Categories