SQL Trace

[arial]

Hi all,

I am new to SQL sever 2000 and database.

I need to write a trace to monitor what is going on with one of my database table?

How can I trace the activity of this perticular table?

Can someone help me with this and point out to a good tutorial for a beginner?

I will really appreciate all your help.

Thank You,

[ck9663]

Hi all,

I am new to SQL sever 2000 and database.

I need to write a trace to monitor what is going on with one of my database table?

How can I trace the activity of this perticular table?

Can someone help me with this and point out to a good tutorial for a beginner?

I will really appreciate all your help.

Thank You,

What kind of trace do you need?

-- CK

[arial]

I am not very familier with trace. What I am trying to do is,
some how I can monitor the activity on this table?

Data gets into this table through a cable sync from a treo device.

After sometimes, data just doesn't get into the table.

I have two sets of table with same schema:

First one i called working table and second one I called a final data.

I have store procedure and trigger runs on working table to validate the data in order to move it to the final table.

It moves the data fine bet sync-wrking table-final table.

But then its just stops the data movement between sync- working table.

The Only way I can start the process working is to delete the data from working table.

And I don't know why it is happening to so, I thought i would trace to see at what point it stops the data sync process.

Thank You,

[ck9663]

If you don't need the final data updated real time, consider running it in batch/job.

-- CK