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

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

  • Next message: Paul Ibison: "Re: Use replication + DTS - Referred to Hilary Cotter or Paul Ibis" 
    Date: Tue, 26 Oct 2004 13:45:04 -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. Will the error log even show what is happening if it hangs?

    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)
    >
    >
    >
    >

  • Next message: Paul Ibison: "Re: Use replication + DTS - Referred to Hilary Cotter or Paul Ibis"

    Relevant Pages