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 |
|
mikebird
Aged Yak Warrior
529 Posts |
 Posted - 2008-02-27 : 10:49:26
|
| Looking in the list of procedures in SQL Server 2005, I'm sure you could run one from there, with an execute menu option.I'm pretty sure you can't do that in 2000? You have to type this at command line? Is there an alternative? Now I have loads of SP I've made and there are others, I'd like quick and simple methods of setting them off...Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-27 : 11:51:22
|
| When you want to execute them? If its on a daily basis you can schedule a job which will execute the stored procedures. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-02-28 : 02:21:25
|
quote:
Originally posted by mikebird
Looking in the list of procedures in SQL Server 2005, I'm sure you could run one from there, with an execute menu option.I'm pretty sure you can't do that in 2000? You have to type this at command line? Is there an alternative? Now I have loads of SP I've made and there are others, I'd like quick and simple methods of setting them off...Thanks
Using query you can doEXEC procedure_name Parameter_lists(If applicable)MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
How to Run an SP in 2000