Re: Repost: Possible SQL Query Analyzer memory leak or other problem
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/31/04
- Next message: Ollie2308: "dynamic sp build"
- Previous message: anonymous_at_discussions.microsoft.com: "Re: Stored Procedure Convert"
- In reply to: Baolin Ren: "Re: Repost: Possible SQL Query Analyzer memory leak or other problem"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 31 Mar 2004 21:04:12 +0200
So there's nothing in the result window in QA, regardless of whether you are executing to text or grid? No, QA
cannot release the memory needed to show the stuff in the result window, you shouldn't be able to scroll
through it if QA released that memory. Did you try using OSQL and an output file?
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp "Baolin Ren" <baolinren@hotmail.com> wrote in message news:d3a61551.0403311049.4f36919@posting.google.com... > Thanks for the reply. Yes, the SET NOCOUNT ON is the first statement > in the script. Anyway, if where are messages returned back from > server, QA should release the memory after displaying the message.
- Next message: Ollie2308: "dynamic sp build"
- Previous message: anonymous_at_discussions.microsoft.com: "Re: Stored Procedure Convert"
- In reply to: Baolin Ren: "Re: Repost: Possible SQL Query Analyzer memory leak or other problem"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
