By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,377 Members | 1,354 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,377 IT Pros & Developers. It's quick & easy.

SQL Trace

100+
P: 109
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,
May 19 '08 #1
Share this Question
Share on Google+
3 Replies


ck9663
Expert 2.5K+
P: 2,878
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
May 19 '08 #2

100+
P: 109
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,
May 27 '08 #3

ck9663
Expert 2.5K+
P: 2,878
If you don't need the final data updated real time, consider running it in batch/job.

-- CK
May 28 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.