how to execute stored procedure using batch file

Question

how to execute stored procedure using batch file

satish-348625

SSC Enthusiast

Points: 194
More actions
June 28, 2007 at 3:10 am

#372501

Hi ,
Can anyone help me ???????????
I want to execute stored procedure using dos batch file .An example wud be appreciated

Satish

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 1

osql -U username -P password -S ServerName -q"exec procedure name"

if you feel that passing user name and passsword is not providing the right security that you want u can use windows authntication method but make sure the user running has necessary permissions.

osql -E -S ServerName -q"exec procedure name"

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com