We have a program (compiled VB) that queries/updates a MSDE RelA database written by a former employee. We dont have source code, just a compiled exe.
We now have need to update this program and need to understand the SQL queries being used by this program. We have SQL profiler and I thought I could use this to actually view the commands outputted by the exe to the SQL database, but all I seem to get is system events, no text.
I used these instructions to setup SQL profiler
Select your server and authentication credentials
Click the Events tab in teh trace properties dialog
Remove Security Audit and Sessions
Add everything from "Stored Procedures" and "TSQL"
Click the Filters Tab, scroll down to Text Data, expand, expand like and enter %UPDATE%
Click Run, then start your application, script whatever.
Click the red stop button when done.