Thank you. The error I posted in my last message was gotten from error log in mirroring server. It looks like the network had issue. It had been worked for...

I am working as database developer  in my current compay, but it was called development dba in my previous company. Both position does almost same work, such as data modeling,...

Hi

Thank you very much. Yes I decide to give up trigger in favour of using job to run the stored procedure. Thanks.

TheSQLGuru,

Thank you very much. why I use a table with a trigger on it is that for performance. Because I have a lot oftables being replicated and a lot of...

Hi guys,

Somebody told me that microsoft doesn't recommand to use replication and trigger together. Is that true? How can I work around? Thanks.