Vbscript in a stored procedure -- sql server programming

Edgardo Valdez, MCSD, MCDBA
4/7/2006 10:29:56 AM

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.

[quoted text, click to view]

Zrod
4/7/2006 6:50:13 PM

hi,

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

Zrod
4/8/2006 12:00:00 AM

Thank you
What i am aiming to, is to have the client do some test on the server
envirmenet.

"Edgardo Valdez, MCSD, MCDBA"
[quoted text, click to view]

Edgardo Valdez, MCSD, MCDBA
4/8/2006 8:46:01 AM

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.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server programming

sql server programming : Vbscript in a stored procedure