Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Front end

Author  Topic 

pmccann1
Posting Yak Master

107 Posts

Posted - 2008-01-02 : 11:58:29
I have a stored procedure that can take up to 2 hours to run, has anyone any ideas on what front end would be best used to call it

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-01-02 : 12:09:48
Before you select a suitable front end, i think it would be better if you could bring down the execution time of stored procedure. Is it using some really slow cursors or big loops?
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2008-01-02 : 12:32:50
Does that mean you want someone to stare at a screen for 2 hours?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2008-01-02 : 12:36:13
A front end that plays a nice 2 hour movie during that time would be perfect!

In all seriousness, can you be more specific about what you need?

- Jeff
http://weblogs.sqlteam.com/JeffS
Go to Top of Page
   

- Advertisement -