试试
CREATE TRIGGER t_insert_lx_card ON [dbo].[kq_yskq]
FOR INSERTASinsert into ldmis2000.dbo.k_carddate (a0188,checkdate,checktime,kq_id,manual_input)
select bh,rq,sj,bc,'1' from inserted
CREATE TRIGGER t_insert_lx_card ON [dbo].[kq_yskq]
FOR INSERTASinsert into ldmis2000.dbo.k_carddate (a0188,checkdate,checktime,kq_id,manual_input)
select bh,rq,sj,bc,'1' from inserted
FOR INSERTASinsert into openrowset('sqloledb','';'GTC';'GTC',ldmis2000..k_carddate)(a0188,checkdate,checktime,kq_id,manual_input)
select bh,rq,sj,bc,'1' from inserted
exec sp_addlinkedsrvlogin 'srv_lnk','false',null,'用户名','密码'
select * from srv_lnk.数据库名.dbo.表名
openrowset('sqloledb','';'GTC';'GTC',ldmis2000..k_carddate)