Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

How to view the SQL in MS Query without executing the query (Excel)? Expand / Collapse
Posted Wednesday, February 26, 2014 8:27 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, August 26, 2016 6:37 PM
Points: 332, Visits: 1,766
We have various "reports" that are essentially data dumps into Excel using MS Query to retrieve data from our sql servers. Sometimes the query is just an exec of a stored proc. From time to time we lack documentation as to what SQL or stored proc is executed for a given Excel file. At the moment, any time we need to examine the query in MS Query, we right-click on the spreadsheet, select "Edit query..." and then the damn query executes -- which is a waste of time.

Does anyone know of a way to halt MS Query from executing the query so that we can simply examine the underyling query itself?


Post #1545434
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse