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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SP

Author  Topic 

vicki
Posting Yak Master

117 Posts

Posted - 2002-04-18 : 16:02:40
if I have the storeprocedure, how I run it in entirprise?

thanks

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2002-04-18 : 16:12:09
create a job
create a t-sql step
type <database>.<owner>.<procname>
save the job
right-click the job and select execute

or

create a dts package
create a execute sql task
type <database>.<owner>.<procname>
run the dts package


<O>
Go to Top of Page
   

- Advertisement -