Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

How to monitor a particular table using profiler


I want observe what entries are getting into a table while I run an
application
OR any activities happening on a particular table
.How to monitor this
You can use the Profiler to monitor this

"prashant" <prashant1@gmail.com> wrote in message

news:1170486442.187038.200350@v33g2000cwv.googlegroups.com...

 There are few ways to do it.  The first way is to start up profiler
or set up server side trace and filter the textdata column with the
table's name.  This way you'll see all activities on the table
including select statements.

 Another way is to create stored procedure for insert, update and
delete statement.  In the stored procedures you can insert a record
into log table with the details that you need.  You can revoke insert,
update and delete statement on the table and let users work with the
stored procedure only.  Notice that anyone that belongs to db_owner
role or sysadmin server role will still be able to work directly with
the table.

 Another option is to create trigger on the table for update, insert
and delete.  In the trigger you can log anything into a log table.
This way you will be able to log all data modification operations
regardless the way that it was done (direct SQL statement or through
stored procedure).

Adi

On Feb 3, 9:07 am, "prashant" <prashant1@gmail.com> wrote:

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc