468,242 Members | 1,587 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,242 developers. It's quick & easy.

Trace on sql table

109 100+
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
2 1242
2,878 Expert 2GB
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
109 100+

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.

Similar topics

1 post views Thread by Alee Ali | last post: by
1 post views Thread by Pushkar | last post: by
6 posts views Thread by latosca68 | last post: by
5 posts views Thread by vsr | last post: by
3 posts views Thread by dan655t | last post: by
4 posts views Thread by kyosohma | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.