Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Programming » General » Query Analyzer
Add to briefcase

Query Analyzer Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
hiemmi
Posted Monday, February 13, 2006 9:37 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, April 20, 2013 8:50 PM
Points: 5, Visits: 14
Hi,

Does anyone know if Query Analyzer stores all the queries that are executed into a history file and if so how do i view the last executed query which i did not save it.

Thanks.


Post #258078
lenmcmanotony
Posted Tuesday, February 14, 2006 5:49 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 02, 2012 9:43 AM
Points: 32, Visits: 9
I might be jumping the gun a bit but I'm pretty sure that you're out of luck. However, if there is such a feature do let me know because I'm forever closing QA windows without saving them.

Good luck retrieving your query.


Gareth Hopkins
SmartData UK - software, web and database developers
Post #258148
David le Quesne
Posted Wednesday, February 15, 2006 4:32 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, August 10, 2010 4:54 AM
Points: 815, Visits: 32

I think Toad for SQL Server (60 days freeware trial version from Quest software) includes this feature.

David

If it ain't broke, don't fix it...
Post #258555
mosaic-287947
Posted Wednesday, February 15, 2006 4:50 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 6:15 AM
Points: 179, Visits: 402

[off-topic]

You can avoid losing unsaved queries by clearing the checkbox "Do not prompt for unsaved files on closure" in the QA options

Post #258561
lenmcmanotony
Posted Wednesday, February 15, 2006 5:04 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, July 02, 2012 9:43 AM
Points: 32, Visits: 9
Good old Microsoft. They always provide a tick box for any problems you're having. I'm still looking for the tick box in the .Net development environment that tells it to stop being so resource hungry.

Thanks.


Gareth Hopkins
SmartData UK - software, web and database developers
Post #258570
bledu
Posted Wednesday, February 15, 2006 11:09 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, February 05, 2013 4:24 AM
Points: 685, Visits: 104
your best bet could be in the transaction log.
query analyser is not that forgiving

Everything you can imagine is real.
Post #258767
JeffB
Posted Wednesday, February 15, 2006 1:21 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, July 18, 2011 10:05 AM
Points: 255, Visits: 70
The transaction log does not store a log of all queries.  It stores the changes that are made to a database.  It is also an unreadable entity.
Post #258823
Yorgs Neil
Posted Wednesday, February 15, 2006 1:26 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, June 08, 2013 1:09 PM
Points: 19, Visits: 96

FYI

A product called Aqua Data Studio stores out a history of queries.

It works with both Oracle and MS SQL .

I have been working with their demo a little bit ; price is reasonable

 
Post #258824
hiemmi
Posted Thursday, February 16, 2006 4:37 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, April 20, 2013 8:50 PM
Points: 5, Visits: 14

FYI.

Instead of figuring out how to find the last unsaved executed query in SQL QA,  I started using Teradata SQL Assistant tool which can be used against most of the databases and stores all the queries in a history file.  The cool thing about this tool is that history file is displayed right in this analyzer in a tabular format and you can just select and also search on whatever previous queries you might have executed.

Thanks to all for your suggestions.


Post #259251
Arjun Sivadasan
Posted Thursday, February 28, 2013 2:54 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, June 13, 2013 9:38 PM
Points: 365, Visits: 703
I was working on a remote machine and while I was away, the machine was restarted. Lost the scripts I had unsaved, or so I thought; and then I came up with this - was a life saver!

SELECT TOP 10
EST.text
FROM sys.dm_exec_query_stats EQS
CROSS APPLY sys.dm_exec_sql_text(eqs.handle) EST
WHERE EST.text LIKE '%text%'
ORDER BY last_execution_time DESC
Post #1424963
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.