跨服务器跨数据库的触发器问题
create TRIGGER Trigger_Insertsmslstel
ON dx_receive FOR INSERT AS
BEGIN
IF @@rowcount=0
RETURN
insert into openrowset('SQLOLEDB','211.91.34.43';'baobao';'123456',baobao.dbo.test)(content)select '11'
END
当表dx_receive有数据插入,无法实现
直接执行insert into openrowset('SQLOLEDB','211.91.34.43';'baobao';'123456',baobao.dbo.test)(content)select '11' 能成功!