log file in SQL Server 7.0

[MDA]

I am using a VB application that is connected to SQL Server database. I would like to know the syntax of the SQL statements that are being passed to the database. Is there anyway to log all activity, i.e. SQL statements that are passed to the database, then view them?

I know there is a log in SQL server for each database but I don't know of a way to view this log, is there a way?

Any help and/or ideas is greatly appreciated.

(please note, this is obviously not my application so I cannot view the code)

Regards

 

[Ruairi]

SQL Server 6.5 client utilities included a program called SQLTrace. This allowed you to view and log the conversations between the server and clients with or without filters. I'm not sure if 7.0 includes something like this. Ruairi

Could your manufacturing facility benefit from real time process monitoring? Would you like your employees to be able to see up to the minute goal and actual production?
For innovative, low cost solutions check out my website.

http://www.plccontroltechnologies.com

 

[TomSark]

You can use the SQL Server profiler and capture the sql statements to a text file or a database file for future viewing. Be sure to capture data for a defined period of time, since profiler can drag your server's performance a bit...
Tom Davis
tdavis@sark.com

http://www.sarkdallas.com