<div>
You can call extended stored procedure xp_cmdshell.<br />
<br />
EXEC master..xp_cmdshell 'dir *.exe'<br />

</div>


You can call extended stored procedure xp_cmdshell.

EXEC master..xp_cmdshell 'dir *.exe'


<div>
lussier, you are new to this forum but for the next time please note that if you have more than one identical answers, accept either the first one or split the point between all of them. Please spend few minutes reading the help ...<br />
<br />
<a href="https://www.experts-exchange.com/help.jsp#hi19" rel="ugc">https://www.experts-exchange.com/help.jsp#hi19</a>
</div>


lussier, you are new to this forum but for the next time please note that if you have more than one identical answers, accept either the first one or split the point between all of them. Please spend few minutes reading the help ...

https://www.experts-exchange.com/help.jsp#hi19 [https://www.experts-exchange.com/help.jsp#hi19]

<div>
Agree with Amit. I did not see your response. i have mutiple windows opened and some times i do not see what &nbsp;others have posted. But I think, lussier picked a more specific answer in this case though.<br />
<br />
Regards.
</div>


Agree with Amit. I did not see your response. i have mutiple windows opened and some times i do not see what  others have posted. But I think, lussier picked a more specific answer in this case though.

Regards.

<div>
<div class="content wysiwyg-content">
I would like to know if i can call a program EXE (.exe) or a batch file (.bat) by in Trigger or a Store Procedure. If so, how? Thanks
</div>
</div>


I would like to know if i can call a program EXE (.exe) or a batch file (.bat) by in Trigger or a Store Procedure. If so, how? Thanks

Call Exe or batch file in a trigger or in a store procedure

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.