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

Trace on sql table

100+
P: 109
Hi all,

I have a sql server 2000. and i have one of the table in my database is getting value from some store procedure or view.

This database is developed by someone else and we don't have any documentation.

what my problem is i am trying to find out how data is getting dump into that table by which process.

Can any one suggetion me how can i find out this?

Also, i am a new to sql server. don't know the complex stuff.

any help is appreciated.

Thank you.,
Oct 7 '08 #1
Share this Question
Share on Google+
2 Replies


ck9663
Expert 2.5K+
P: 2,878
You have a number of option.

1. Use the profiler

2, Find all stored proc that access this table and open it one by one.

-- CK
Oct 7 '08 #2

100+
P: 109
Hi,

Can I apply Trace to a perticular database Table?
Also, is there a way to look for view in Trace like Store Procedure?

waiting for any suggestion.

Thank you,
Oct 16 '08 #3

Post your reply

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