Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-29 : 22:39:15
|
shweta writes "hi
i want to copy a sql table from my local sql server to my remote sql server using vpn using a dts EACH TIME the content of my local table is changed. so i decided to use a trigger like this
USE utilities
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'triggertest' AND type = 'TR')
DROP TRIGGER triggertest
GO
CREATE TRIGGER triggertest
ON tablena,name
FOR INSERT, UPDATE,DELETE
AS
blah blah blah
GO
my question is:
how do i call my dts here???
is this sufficient to achieve what i want?
pleazzzzzzzzzzzzzze help me!
thanks a ton
shweta" |
|
|
|
|
|
how to call a dts from trigger