triggers RRS feed

  • Question

  • I am trying to write a trigger to insert data onto another server table:



    col1 char (5)

    col2 char(5)

    col3 int



    col1 char (5)

    col2 char (5)

    col3 int

    col4 pk int

    # Note: col4 is an Identity column


    server1 new record added


    trigger after insert


    insert into server2.db2.dbo.tab2 values (col1,col2,col3)


    First it complained that the structure for the insert was wrong so

    I added the (col4)


    Now I get "The data value violated the integrity constraints for the column"


    Can anyone help.



    Thursday, August 28, 2008 1:45 PM



    Hi Jeffwh, after checking the issue, it seems this is a general Windows Server related issue. As this forum focuses on Windows SteadyState specific issues, this inquiry would best be posted to Windows Server newsgroup:




    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the newsgroups regularly can either share their knowledge or learn from your interaction with us.  Thank you for your understanding.

    Monday, September 1, 2008 5:47 AM