本文介绍了触发器将如何执行exe:的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嗨朋友。, 我在触发器上使用以下命令在表格中插入行时发送电子邮件: EXEC master..xp_cmdshell'C:\Project\Mail.exe' 现在, 任何人都可以告诉我它将如何执行? 触发器是否会等到Mail.exe完成工作?
Hi Friends., I am using the following command on trigger to send email while insert rows in a table: EXEC master..xp_cmdshell '"C:\Project\Mail.exe"' Now, Can anyone let me know how it will be executed? Whether the trigger will wait until the Mail.exe finish the work?
推荐答案你读过文档吗? http:// technet。 microsoft/en-us/library/aa260689(v=sql.80).aspx [ ^ ] 它声明: xp_cmdshell同步运行 。在命令shell命令完成之前不会返回控制 Did you read the docs? technet.microsoft/en-us/library/aa260689(v=sql.80).aspx[^] It states that: "xp_cmdshell operates synchronously. Control is not returned until the command shell command completes"
更多推荐
触发器将如何执行exe:
发布评论