Re: Use replication + DTS - Referred to Hilary Cotter or Paul Ibis

From: Mad Matt (MadMatt_at_discussions.microsoft.com)
Date: 10/26/04 

Date: Tue, 26 Oct 2004 13:39:15 -0700

Paul,

Syntax appears to be correct writing something similar to this but when it
goes to execute the trigger it hangs. Ran it in query analyzer and a message
at the bottom simply says executing query batch...

Any suggestions as to why this is happening or how I can go about debugging
this.

Thanx,

"Paul Ibison" wrote:

> Matt,
> try something like:
>
> CREATE TRIGGER copy_Order ON [dbo].[orders]
> FOR INSERT
> AS insert into servername.databasename.dbo.orders(idOrder,
> orderDateEntered)
> select idOrder, orderDateEntered from inserted
>
> HTH,
> Paul Ibison (SQL Server MVP)
>
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
>
>

Relevant Pages
Loading