Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exec Large Stored Procedure

Status
Not open for further replies.
dvannoy

dvannoy

MIS
May 4, 2001
2,765
0
0
US
I'm looking for a way to execute a Stored Procedure and return the rows fetched back to a message box. I have a scheduled SP that just runs on our server that goes out and pulls data from another system into a SQL table on one of our servers. I currently have the job (SP) scheduled to run every 30 minutes. everything works fine but I need a way for the user to force run the SP from an windows form and return the rows fetched. I don't need any data returned or there are no parameters at all, just need to execute the SP by pressing a button. the SP can take up to 5 mins to complete depending on the amount of records. I use SP's in my app currently but not this way. I'm trying to avoid timeout errors as well.

Any help would be appreciated


 
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
  • Question
execute .bat as administrator
Replies
2
Views
43
strongm
strongm
Adonetok
  • Locked
  • Question
Error: The Specified Executable Is Not A Valid Application For This OS
Replies
1
Views
98
jebenson
jebenson
Andrzejek
  • Locked
  • Question
(Oracle) Stored Proc returning rst back to VB6
Replies
3
Views
41
Andrzejek
Andrzejek
pmegan
  • Locked
  • Question
ODBC data source missing stored procedures
Replies
0
Views
24
pmegan
pmegan
vladk
  • Locked
  • Question
Collection was modified enumeration operation may not execute
Replies
1
Views
43
vladk
vladk

Part and Inventory Search

Sponsor

Back
Top