<div>
EXEC xp_cmdshell 'cscript myscript.vbs';<br />

</div>


EXEC xp_cmdshell 'cscript myscript.vbs';


<div>
Thanks weellio! That's a start. But do you know how I would pass the username field from the text file insert? Could I do:<br />
<br />
EXEC xp_cmdshell 'cscript myscript.vbs col002';<br />
<br />
Or something like that?<br />
<br />
Sorry, rank beginner here.<br />

</div>


Thanks weellio! That's a start. But do you know how I would pass the username field from the text file insert? Could I do:

EXEC xp_cmdshell 'cscript myscript.vbs col002';

Or something like that?

Sorry, rank beginner here.


<div>
<div class="content wysiwyg-content">
I have a text file to import. One of the fields is username. I have a vbscript to determine full name from AD username. I want the trigger to use the vbscript to determine the full name from the username and insert that information to a field the row.
</div>
</div>


I have a text file to import. One of the fields is username. I have a vbscript to determine full name from AD username. I want the trigger to use the vbscript to determine the full name from the username and insert that information to a field the row.

How can I call a vbscript from an SQL trigger?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.