May 6, 2008 at 2:40 pm
There is vbscript in a table that is triggered by an event, I don't know how does this code gets executed. Could anyone explain?
May 7, 2008 at 6:06 am
That depends. It could be that it's returned to an application as a result set and then run as a script by the app. It could be that it gets pulled out by an internal procedure that then calls out to the command shell and executes it. It's possible that someone has a CLR app that will accept VBS and execute it. There may be other options I've missed. The one thing I can say is that it would require some type of external call because nothing internal to SQL Server will run VB scripts.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 7, 2008 at 7:20 am
Grant,
Thank you for sharing the options. I just had one option.
I will keep looking, this is a very dark application that offers windows for customization, but under its rules.
This topic can be closed.
Yiddy
May 7, 2008 at 8:41 am
HI, i have one query...
i need to execute Some VB Script from sql query window(management studio). can you please help me out.
purpose is...
i am planning to get the expiry date of a "domain account" from vbscript and insert into sql server..
i need to execute this vb script through trigger so that if any one updates a password in sql server i need to udpate that account expiry date also in that table to avoid manual entry....
plsease suggest..
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply