Help | Site Map
Connecting Tech Pros Worldwide
Reply
 
LinkBack Thread Tools
  #1  
Old October 7th, 2008, 05:22 PM
Member
 
Join Date: Sep 2007
Posts: 107
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, 06:04 PM
ck9663's Avatar
Expert
 
Join Date: Jun 2007
Posts: 1,509
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, 07:34 PM
Member
 
Join Date: Sep 2007
Posts: 107
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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

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 network members.
Post your question now . . .
It's fast and it's free

Popular Articles