Trace on sql table

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.,

re: Trace on sql table

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

re: Trace on sql table

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,