Vbscript in a stored procedure

7 Apr 2006 3:50 PM

Zrod

hi,

IS there a way to write vbscript , or call an execultable within a stored
procedure?

7 Apr 2006 5:29 PM

Edgardo Valdez, MCSD, MCDBA

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

8 Apr 2006 7:20 AM

Zrod

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

8 Apr 2006 3:46 PM

Edgardo Valdez, MCSD, MCDBA

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