|
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 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 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 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? > >> > >> > >> > > > |
|||||||||||||||||||||||