Re: View Uncommitted Query or Data in Sql 2K ?

From: Hugo Kornelis (hugo_at_pe_NO_rFact.in_SPAM_fo)
Date: 02/05/05 

Date: Sun, 06 Feb 2005 00:04:07 +0100

On Sat, 5 Feb 2005 16:54:43 +0500, Luqman wrote:

>By view uncommitted query, I mean if I run 03 queries, one for Insert, one
>for update and one for delete, and still did not issue commit, and clear the
>sql window,
>now can I see those queries again.

Hi Luqman,

No, you can't, unless it is still in the undo buffer of Query Analyzer.
This is functionality of QA, though - not of the core server.

If you already had a profiler trace running when you submitted the query,
then you could find the query there.

>2ndly when I close the query analyzer window, it says, you have uncommitted
>data, do you want to commit, can I see what data its referring to, out of
>above 03 queries.

I think you can cancel the close operation (not sure, though, and I can't
experiment now). Then, close the windows in QA one by one. Each window
that has an open connection will ask you to commit or rollback.

Best, Hugo 

-- 
(Remove _NO_ and _SPAM_ to get my e-mail address)

Relevant Pages

  • Access queries have very bad manners
    ... In my long queries, if my screensaver comes on, or I open a new window (say ... the Access window does not repaint until the query has ... I am curious as to how the progress bar at the ...
    (microsoft.public.access.queries)
  • Re: Get External Access data
    ... Any Select query that relies on the value of a Control on an open ... queries are of 2 types: ... to recall that the use of NZwithin a query would also make it fail this ... Queries (referred to in the window as View) in it. ...
    (microsoft.public.excel)
  • Re: Macro Help!
    ... Delete query #1: ... You can copy the statement for one of the delete queries into the ACCESS ... Open a new query in design view, close the window that shows ... <MS ACCESS MVP> ...
    (microsoft.public.access.macros)
  • Re: COUNT
    ... I have just tested a performance issues of both queries on very large result ... benefits by using your query. ... >> If you really, really, really want this all in one query, you can commit ... > You could also do the following which has behaves somewhat better ...
    (microsoft.public.sqlserver.programming)
  • Re: Get External Access data
    ... Any Select query that relies on the value of a Control on an open ... Form would also fail the "available external data" test (again, Access, ... queries are of 2 types: ... When I do a window comes up with Access Tables ...
    (microsoft.public.excel)