从SQL Trigger启动EXE [英] Launch EXE from SQL Trigger

问题描述

大家好



你能否解释一下如何从SQl中插入EXE（C＃应用程序）插入Trigger with Example？



问候

Prasath

Hi All

Could you anyone explain how to launch an EXE(C# Application) from SQl insert Trigger with Example?

Regards
Prasath

推荐答案

不要这样做。您打开一个难以控制的安全门户。最好创建一个 CLR集成触发器 [ ^ ]。



如果你坚持这个想法，搜索 xp_cmdshell触发器关键字。并阅读： http：//www.mssqltips .com / sqlservertip / 2143 / creating-a-sql-server-proxy-account-to-run-xpcmdshell / [ ^ ]

Don''t do that. You open a security portal, that is hard to control. Better create a CLR integrated trigger[^] in c#.

If you stick to that idea, search on xp_cmdshell trigger keywords. And read this: http://www.mssqltips.com/sqlservertip/2143/creating-a-sql-server-proxy-account-to-run-xpcmdshell/[^]

这篇关于从SQL Trigger启动EXE的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！