none
Linked server RRS feed

  • Question

  • I am trying to execute trigger that updates the table on linked server. Linked server is SQL 2005 on Windows 2000 SP4 and
    source is SQL 2000 SP 4 on Windows 2000 SP4. While I execute the query independently(insert into linkserver1.newdb.dbo.a_table (slno)values('1')) from source server the table on linked server get updates, so I assumed that linked server is working properly. But using trigger I am not able to do so. Can anybody help

     
    Thursday, July 9, 2009 10:34 AM

All replies

  • You might like to post this on the SQL Server forum instead.

    Regards

    Joe

    Write LINQ queries interactively - www.linqpad.net
    Thursday, July 9, 2009 2:35 PM
    Answerer