locked
triggers RRS feed

  • Question

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

     

    server1.db1.dbo.tab1

    col1 char (5)

    col2 char(5)

    col3 int

     

    server.db2.dbo.tab2

    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

Answers

  •  

    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:

     

    http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.windows.server.general

     

    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