Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
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: Sunday, July 27, 2014 8:47 PM
Points: 316, Visits: 1,483
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?

Thanks,
Pete



Post #1545434
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse