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
 trigger a sp in a batch file

Author  Topic 

allan8964
Posting Yak Master

249 Posts

Posted - 2008-07-02 : 10:30:12
is there any way i can trigger a stored procedure thru some Windows batch file or some simpler way? thanks.

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2008-07-02 : 11:35:20
Check out OSQL in books online.

-------------
Charlie
Go to Top of Page

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2008-07-02 : 11:36:30
Link

http://technet.microsoft.com/en-us/library/aa214012(SQL.80).aspx

-------------
Charlie
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-07-02 : 13:21:09
or create a job to call the stored procedure and schedule it
Go to Top of Page

allan8964
Posting Yak Master

249 Posts

Posted - 2008-07-02 : 16:34:31
thanks to you all, i found sqlcmd.exe which works similar as osql or isql. thank you again
Go to Top of Page
   

- Advertisement -