Re: who or what is accessing my table?

Tech-Archive recommends: Fix windows errors by optimizing your registry

j,

You probably should spend more time to learn Profiler. You could put a
delete trigger on the table and write to an audit table - this is more
complex than learning Profiler.

-- Bill

"jmelkerson" <jmelkerson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6BAC1023-805E-4AC4-BE1C-006F8F67ECBA@xxxxxxxxxxxxxxxx
I have a situation where records are mysteriously disappearing from a
table.
How can I monitor the table to discover who or what is accessing it or
executing statements or stored procedures on it? I have tried SQL
Profiler
but don't know how to filter properly.


.

Relevant Pages

  • Re: Auditing changes made to table design (syscolumns table)
    ... With out using profiler the only way I know of is to get this info from the ... Keep in mind I know the database and the tables I would ... I attempted to write a trigger to log when a change was made to the ... > certain criteria against every transaction. ...
    (microsoft.public.sqlserver.security)
  • Re: Update changed columns only
    ... And inside the trigger do you use the UPDATEfunction ... For now I would like to make 100 % that you see in SQL Profiler the SQL ... To know for sure the best way is to see the SQL statement using the SQL ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Updating Subscriber Question
    ... Through profiler I have determined the process is hanging up in the update ... trigger when the sp_MSget_publisher_rpc procedure is called. ... MSsubscription_properties table is queried to get the login id for the ... "Paul Ibison" wrote: ...
    (microsoft.public.sqlserver.replication)
  • Re: inserted in Trigger auswerten
    ... Ich habe mich mit dem Profiler ... Meine Trigger funktionieren übrigens gut. ... Prev by Date: ... Next by Date: ...
    (microsoft.public.de.sqlserver)
  • Re: Obtain Info
    ... How to Enable the Audit for Logins:- ... SQL 2000 - Open enterprise manager -- Right click on server and select ... you need to use Profiler for that. ...
    (microsoft.public.sqlserver.security)