dbTalk Databases Forums  

Terminating an Analysis Services (AS) Query in EXCEL

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Terminating an Analysis Services (AS) Query in EXCEL in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mike
 
Posts: n/a

Default Terminating an Analysis Services (AS) Query in EXCEL - 02-17-2004 , 08:11 AM






Is there anyway to terminate an AS Query in EXCEL when the "ESCAPE"
key is pressed. We are having some issues where the end-user will
terminate the EXCEL execution of a AS Query (via PTS) by hitting the
ESCAPE key. The ESCAPE key is freeing the EXCEL session and allowing
the end-user to issue other AS Queries, but the query is still running
on the server.

Thanks

Reply With Quote
  #2  
Old   
Lutz Morrien
 
Posts: n/a

Default Terminating an Analysis Services (AS) Query in EXCEL - 02-17-2004 , 10:31 AM






Hi Mike,
as long as the query is executed on the clientside,
shutting down and restarting excel will stop the query.

If you are working server side, the only way to stop a
query is shutting down AS server.

This is as far as I know,
Lutz Morrien

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.