Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 New to trace files, am I on the right track?

Author  Topic 

smac75
Starting Member

2 Posts

Posted - 2009-05-22 : 08:58:30
Hi, I am new to sql trace files / analyzer / profiler (but not new to SQL Server) and I'm wondering if I am looking in the right place. Quite simply I need to add records via an application (web-based app with sql back-end) and I need to see exactly which tables get hit. Is this where trace files come in? Is creating a trace file the only way to determine which tables are being populated?

Thank you!

mcrowley
Aged Yak Warrior

771 Posts

Posted - 2009-05-22 : 09:42:12
It is one way to figure it out. Have you asked the vendor what tables get updated?
Go to Top of Page

smac75
Starting Member

2 Posts

Posted - 2009-05-22 : 10:02:06
Thank you for replying! The app is an IBM app and we currently do not have a support agreement with them so i'm pretty sure they would charge me to ask this question! I was hoping to avoid this, plus, I need to perform this analysis on a number of different inserts.
Go to Top of Page
   

- Advertisement -