Stored Procedure Calling Batch File

[jhampton13]

I would like to call a batch file from a stored procedure, something like

If (this happens)
then (call xxxx.bat)

I know there are some ways of doing this by stepping outside of the database into the O/S and then calling the batch file, but I have been searching for an easier way. If anyone knows a way that I can call the batch file to run directly from the stored procedure, it would be greatly appreciated.. Thanks...

 

[dafdba]

You can use the extended stored procedure xp_cmdshell in the master database for this.

 

[MKVAB]

jhampton13, what do you want to do with the batch file? Grab the file and then load it?

 

[Cagliostro]

Ok, there are tow utilities, isql.exe and isqlw.exe, you can use them in a .bat file like this:

isql -SserverName -UuserName -Ppassword -isomefile.sql

where the content of somefile.sql could be for example
use somedatabase
go
select * from sometable
go

Ion Filipski

 

[MKVAB]

Oh, .bat...my mind is stuck in bulk insert mode!
Not sure if you can call isql from a batch file. It'd be a good thing to know though!

 

[jhampton13]

Thanks for your help. I'm pretty sure that if I use an extended stored procedure, this will work ok. Thanks again

 

[millerk]

Be very careful about permissions on xp_cmdshell.
It is very very dangerous.