|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Vbscript in a stored procedurehi,
IS there a way to write vbscript , or call an execultable within a stored procedure? You can use xp_cmdshell:
E.g. exec master xp_cmdshell 'cscript [your vbscript].vbs' However it will basically start a shell session in the OS and execute the script and close the session. I guess what I am aiming at, is the is not a very elegant solution, however, you can use it id you absolutely need to. Show quoteHide quote "Zrod" wrote: > hi, > > IS there a way to write vbscript , or call an execultable within a stored > procedure? > > > Thank you
What i am aiming to, is to have the client do some test on the server envirmenet. "Edgardo Valdez, MCSD, MCDBA" <EdgardoValdezMCSDMC***@discussions.microsoft.com> wrote in message Show quoteHide quote news:F86F5BB9-C7E4-4618-B39E-89353825EF98@microsoft.com... > You can use xp_cmdshell: > > E.g. > > exec master xp_cmdshell 'cscript [your vbscript].vbs' > > However it will basically start a shell session in the OS and execute the > script and close the session. I guess what I am aiming at, is the is not a > very elegant solution, however, you can use it id you absolutely need to. > > "Zrod" wrote: > >> hi, >> >> IS there a way to write vbscript , or call an execultable within a stored >> procedure? >> >> >> I guess it is fine for testing. The stored procedure will only return the
output from the shell session after the vbscript or any exe is executed. Show quoteHide quote "Zrod" wrote: > Thank you > What i am aiming to, is to have the client do some test on the server > envirmenet. > > "Edgardo Valdez, MCSD, MCDBA" > <EdgardoValdezMCSDMC***@discussions.microsoft.com> wrote in message > news:F86F5BB9-C7E4-4618-B39E-89353825EF98@microsoft.com... > > You can use xp_cmdshell: > > > > E.g. > > > > exec master xp_cmdshell 'cscript [your vbscript].vbs' > > > > However it will basically start a shell session in the OS and execute the > > script and close the session. I guess what I am aiming at, is the is not a > > very elegant solution, however, you can use it id you absolutely need to. > > > > "Zrod" wrote: > > > >> hi, > >> > >> IS there a way to write vbscript , or call an execultable within a stored > >> procedure? > >> > >> > >> > > >  
Other interesting topics
Advanced T-SQL Question: Produce Backup Window Gantt Chart
assign a table to a path and filename? Prioritise the execution of a specific Stored Procedure Unexpected NOT IN results SQL Performance difference Invalid Column Names? Why am I missing rows in my result set? [OT] There should be a law... how to get back image from table? Storing text files in a column |
|||||||||||||||||||||||
