在触发器中调用扩展存储过程一问,多谢各位:)
触发器中就是调用master库中的一个扩展存储过程,将新增的行数传递给它,然后扩展存储过程调用外部dll将新增行数写到一个文本中。
如果直接执行扩展存储过程,执行都是正确的;但如果通过触发器来执行时,有如下错误提示:
Server: Msg 15002, Level 16, State 1, Procedure sp_addextendedproc, Line 12
The procedure 'sp_addextendedproc' cannot be executed within a transaction.
Server: Msg 15002, Level 16, State 1, Procedure sp_addextendedproc, Line 12
The procedure 'sp_addextendedproc' cannot be executed within a transaction.
Server: Msg 2812, Level 16, State 62, Line 13
Could not find stored procedure 'SetFileName'.
The statement has been terminated.
请问这是什么错误?如何修改呢?多谢!