All geek questions in one place

Is there a tool for tracking SQL statements executed with .EXE?

I would like to be able to connect to a third-party application to see which SQL queries are being executed. In particular, it is a VB6 application running on SQL Server 2005.

For example, when an application fills the grid, I would like to see which particular request generated this data.

+4
source share
4 answers

If you have the appropriate permissions (sysadmin or ALTER TRACE), you can watch using SQL Profiler.

+11
source

If the application does not write a magazine or something like that, the only way to look at them is on the database side. SQL Profiler is the right tool for the task in MSSQL 2005.

+1
source

You can view it on the server side by connecting to the SQL server using the SQL Server Profiler included in the tools. It uses its use from Microsoft

+1
source

Looking at it on the server, as other answers indicate, is most likely the best way. However, if this is not available, you can also include the ODBC log , which can be useful.

0
source

Source: https://habr.com/ru/post/1276987/

More articles:


All Articles