Connecting Tech Pros Worldwide Help | Site Map

Trace on sql table

 
LinkBack Thread Tools Search this Thread
  #1  
Old October 7th, 2008, 04:22 PM
Member
 
Join Date: Sep 2007
Posts: 108
Default 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.,
Reply
  #2  
Old October 7th, 2008, 05:04 PM
ck9663's Avatar
Expert
 
Join Date: Jun 2007
Posts: 1,809
Default

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
Reply
  #3  
Old October 16th, 2008, 06:34 PM
Member
 
Join Date: Sep 2007
Posts: 108
Default

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

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search


Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,989 network members.