Trigger insert not replicating

  • Hello, I have two tables setup. The first called Main has two way transactional replication setup with another database. In this other database there is a table called Target1. If I enter data directly into Target1 it replicates back to Main like it should but if data is inserted into Target1 from an insert trigger from another database it never replicates back to Main even though it is in Target1. Target1 also has a pull subscription from Main. Any help would be appreciated.

  • This was removed by the editor as SPAM

  • Two as in you've implemented transactional with immediatley updating subscribers, or true bi-directional where each subscribes to the other?

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

  • I found out the problem was with security. My server only allowed Windows security and it should have allowed SQL Server and Windows logins.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply