Home Forums SQL Server 2008 SQL Server 2008 Administration Create DML trigger for single table for a Database in SQL 2008R2 RE: Create DML trigger for single table for a Database in SQL 2008R2

  • May 2, 2014 at 7:13 am

    #1710328

    Did you verify your linked server permissions on the secondary database server to make sure it can actually access the database / table and write to it?

    EDIT: And are you sure your trigger is actually returning any values?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.