sql2005 触发器在两个数据库间通信

具体实例如下:

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[sc_checkresult] ON ritekdb.[dbo].[CheckResult] 
FOR INSERT
AS
BEGIN
declare @num int 
declare @total_num int
Select @num=count(num) from ritekdb.[dbo].[CheckResult]
TRUNCATE TABLE progressbar.[dbo].[T_h]
select @total_num=count(num) from ritekdb.[dbo].[meas_element]
insert into progressbar.[dbo].[T_h](num,total_num) values(@num,@total_num)
END

上面的dbo不可缺少否则无法编译通过