Groups > comp.databases.ms-sqlserver > #1641

Re: Need example showing how to log DML events for a table

From	JoeM <noreply@replytogroup.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Need example showing how to log DML events for a table
Date	2013-12-31 13:33 -0800
Organization	A noiseless patient Spider
Message-ID	<l9vd5r$v9l$1@dont-email.me> (permalink)
References	<l9taut$1rh$2@dont-email.me> <XnsA2A76D973EE1CYazorman@127.0.0.1> <l9vb0r$jbd$1@dont-email.me> <XnsA2A7E0513E885Yazorman@127.0.0.1>

Show all headers | View raw

On 12/31/2013 1:03 PM, Erland Sommarskog wrote:
> Yes and no. You can use the command DBCC INPUTBUFFER for this purpose, but
>
> 1) It requires high permissions, even for your own spid. This can be
> addressed with certificate signing, but given the next points, I don't think
> it's worth the hassle.
>
> 2) If the DML statement was executed inside a stored procedure, you will
> only see the call to the stored procedure.
>
> 3) If the application uses parameterised statements (which it should), you
> will only see the parameter names.

Thanks much.  I'll just keep it simple then.  Know of any good 
examples showing how to set it up?

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

Need example showing how to log DML events for a table JoeM <noreply@replytogroup.com> - 2013-12-30 18:42 -0800
  Re: Need example showing how to log DML events for a table Erland Sommarskog <esquel@sommarskog.se> - 2013-12-31 10:46 +0100
    Re: Need example showing how to log DML events for a table JoeM <noreply@replytogroup.com> - 2013-12-31 12:56 -0800
      Re: Need example showing how to log DML events for a table Erland Sommarskog <esquel@sommarskog.se> - 2013-12-31 22:03 +0100
        Re: Need example showing how to log DML events for a table JoeM <noreply@replytogroup.com> - 2013-12-31 13:33 -0800

csiph-web