Can you view what queries are being run against the server?

  • Hi - I have inherited a desktop app (compiled exe) which runs queries against a SQL database.

    Old story, the developer of the app has left, with no documentation - and all hard coded SQL in the exe.

    Is there a way from the logs/query analyzer anywhere, that I can view the SQL statements being processed by the server while this application is running?

    We want to rewrite the app and move the queries to SProcs.

    Thanks for any help,

    Mark

  • Run the profiler while you hit all the possible buttons and you'll see the queries being fired at the server. Don't forget to filter the queries to only yourself.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply