pull sql query execution location from either the sql server or IIS
- by jon3laze
I am working on restructuring the database for a project that has hundreds of classic asp pages. I need to be able to find out which pages are executing which queries so that I can analyze the data. I am hoping there is some way to accomplish this without having to manually open each asp page and copy/paste the queries into a spreadsheet. I would imagine this should be something I could pull from possibly logs? Any info is appreciated.
IIS 7
MSSQL 2008 R2
Windows Web Server 2008 build 6001