How can I break long request 
Author Message
 How can I break long request
How I can interrupt work of long request?
As it is made in QueryAnalizer.

__________________________________________________________________ Alexey
Ospanov ICQ#: 158760584 Current ICQ status: + More ways to contact me
__________________________________________________________________



Sat, 20 Nov 2004 18:20:37 GMT
 How can I break long request

Hi Alexey,

If you want to stop a query then just press the 'Stop' button in the Query
Analyzer toolbar. If you want to end a spid that appears hung then use the
KILL command. However, even if you KILL your spid, your query will still
rollback. I do recommend caution when using KILL especially if you are
running UPDATES or DELETES.

Does this help with your situation?

Jimbo


Quote:
> How I can interrupt work of long request?
> As it is made in QueryAnalizer.

> __________________________________________________________________ Alexey
> Ospanov ICQ#: 158760584 Current ICQ status: + More ways to contact me
> __________________________________________________________________



Sat, 20 Nov 2004 19:10:57 GMT
 How can I break long request


Quote:
> Hi Alexey,

> If you want to stop a query then just press the 'Stop' button in the Query
> Analyzer toolbar. If you want to end a spid that appears hung then use the
> KILL command. However, even if you KILL your spid, your query will still
> rollback. I do recommend caution when using KILL especially if you are
> running UPDATES or DELETES.

> Does this help with your situation?

No. I wanted to find out how to interrupt request in my program?

__________________________________________________________________ Alexey

Quote:
> > Ospanov ICQ#: 158760584 Current ICQ status: + More ways to contact me
> > __________________________________________________________________



Mon, 22 Nov 2004 16:58:40 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. break long words input

2. How to break a long line of ToolTipText?

3. break long words

4. Problem with long break while fetching rows

5. any improved efficiency over breaking long fields

6. Breaking long text fields in FMP6

7. How to Cancel long SQLAnyWare request

8. Long Datatypes - Storing of BLOB data on remote database, ( by request )

9. HELP: Abysmal Ingres performance - Data posted as requested [LONG]

10. MDX : Canned Report or OLAP

11. Anyone know of some canned (cheap or free) DB performance testing software

12. canned code to get db on web quickly via perl or


 
Powered by phpBB® Forum Software