Is there any way to identify which records in a SQL database were 'read'
and by whom? Thanks.
Message posted via http://www.droptable.comBy "read", do you mean returned by a query or involved in a query
computation? Even in a modestly large system, that could be tens of millions
of rows per day. That said, there is perhaps a method to extract this
information from a SQL Profiler event.
"Carolyn via droptable.com" <forum@.droptable.com> wrote in message
news:c8ba5f4b6213454d88acc5502db49860@.SQ
droptable.com...
> Is there any way to identify which records in a SQL database were 'read'
> and by whom? Thanks.
> --
> Message posted via http://www.droptable.com
Showing posts with label identify. Show all posts
Showing posts with label identify. Show all posts
Wednesday, March 21, 2012
'read' audit
Is there any way to identify which records in a SQL database were 'read'
and by whom? Thanks.
Message posted via http://www.sqlmonster.com
By "read", do you mean returned by a query or involved in a query
computation? Even in a modestly large system, that could be tens of millions
of rows per day. That said, there is perhaps a method to extract this
information from a SQL Profiler event.
"Carolyn via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:c8ba5f4b6213454d88acc5502db49860@.SQLMonster.c om...
> Is there any way to identify which records in a SQL database were 'read'
> and by whom? Thanks.
> --
> Message posted via http://www.sqlmonster.com
and by whom? Thanks.
Message posted via http://www.sqlmonster.com
By "read", do you mean returned by a query or involved in a query
computation? Even in a modestly large system, that could be tens of millions
of rows per day. That said, there is perhaps a method to extract this
information from a SQL Profiler event.
"Carolyn via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:c8ba5f4b6213454d88acc5502db49860@.SQLMonster.c om...
> Is there any way to identify which records in a SQL database were 'read'
> and by whom? Thanks.
> --
> Message posted via http://www.sqlmonster.com
Subscribe to:
Posts (Atom)