--先給你一個簡單例子看CREATE TRIGGER TRIG_TabXY
ON server1.db1.dob.TabX
AFTER INSERT
AS
IF (SELECT min(salary) FROM inserted)>0
BEGIN
INSERT INTO server2.db2.dbo.TabY(dept_no,person_no,sex,salary)
SELECT dept_no,person_no,sex,salary FROM inserted
PRINT 'TabX有記錄增加了,同時觸發TabY。'
ENDGO
ON server1.db1.dob.TabX
AFTER INSERT
AS
IF (SELECT min(salary) FROM inserted)>0
BEGIN
INSERT INTO server2.db2.dbo.TabY(dept_no,person_no,sex,salary)
SELECT dept_no,person_no,sex,salary FROM inserted
PRINT 'TabX有記錄增加了,同時觸發TabY。'
ENDGO
to :你是说远程控制吧?什么服务器客户机的。装个WINVNC就行了。是啊!这个WINVNC是个硬件吧!