cancel executing query

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Programming » Connecting » cancel executing query

cancel executing query

Rate Topic

Display Mode

Topic Options

Author

Message

Gaby Lever-314483

Posted Monday, October 22, 2007 12:35 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, December 16, 2007 11:59 PM
Points: 2, Visits: 5

We are using Crystal Reports for creating reports for our website. When an user selects a report a new window opens and the crystal report is starting to generate. The sql query is executing on our database. When the user closes the window the query is still executing up to serveral minutes. So is there a way to cancel the query when the user is closing the browse.

Thx in advance
Greetings

Post #413276

okhere

Posted Monday, October 22, 2007 12:40 AM

Valued Member

Group: General Forum Members
Last Login: Sunday, April 21, 2013 8:40 PM
Points: 57, Visits: 174

Hi,

Go to the homepage of your Reporting Services:

http://yourservername/reports/Pages/Folder.aspx

then Site Settings (on the far top right)

then Manage Jobs (on the bottom left)

you can then kill any process that is currently active.

I hope that helps.

Thanks

Osama

Post #413277

Gaby Lever-314483

Posted Monday, October 22, 2007 1:19 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, December 16, 2007 11:59 PM
Points: 2, Visits: 5

It's not an option to do this by hand. We want to do this in code (C#, asp.net)

Post #413287

« Prev Topic | Next Topic »

Permissions