Track Query Execution

[drublic1019]

I am using MS SQL 2005 and I have a problem with some old reports and VB applications on our server. Some time ago an individual here wrote some reports and apps that pull data for our sql server to create EDI files. The problem I am running into is I need to make some changes to the data it is pulling but I cannot figure out where it is pulling it from. Is there a way that I can log all queries and store procedures executed on my server to find this?

Thanks.

 

[ptheriault]

Yes, use SQL Server profiler.

- Paul
- If at first you don't succeed, find out if the loser gets anything.