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.
| Author |
Topic |
|
gudushen
Starting Member
16 Posts |
 Posted - 2008-10-27 : 11:06:15
|
| Hi, just like the subject said, I'm trying to make an exe that runs a stored procedure. I've been searching online with little success, any help would be appreciated.Thank yougudushen |
|
|
hanbingl
Aged Yak Warrior
652 Posts |
Posted - 2008-10-27 : 11:09:40
|
| Please specify your needs. You can always script the stored procedure to run as either a Job or a BAT file. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-27 : 11:11:39
|
| why do you want to run stored proc from an exe? can you explain what you're trying to do? |
|
|
|
gudushen
Starting Member
16 Posts |
Posted - 2008-10-27 : 11:14:03
|
quote:
Originally posted by visakh16
why do you want to run stored proc from an exe? can you explain what you're trying to do?
sorry, basically, I want to use Windows Scheduled Task to run an exe, which runs the script nightly. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-27 : 11:17:40
|
quote:
Originally posted by gudushen
quote:
Originally posted by visakh16
why do you want to run stored proc from an exe? can you explain what you're trying to do?
sorry, basically, I want to use Windows Scheduled Task to run an exe, which runs the script nightly.
why use Windows scheduled task? cant you set up a SQL Server agent job to execute stored procedure each night? |
|
|
|
|
|
|
creating exe to run sql stored procedure