Hi All,
Has anyone created table triggers for the tables in a SQL Server replication database?
Is this safe to do?
I suspect it is but I was looking for some feedback first.
I need to store the individual sales reps on a sales order in a separate table because Epicor stores them in a tilde delimited list in OrderHed.SalesRepList
I thought that using table triggers would be the best way.
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
addr: 37 Shuman Ave | Stoughton | Ma | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring
[cid:0ab8c4.png@70af9cdb.47ae9545]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
[Non-text portions of this message have been removed]
Has anyone created table triggers for the tables in a SQL Server replication database?
Is this safe to do?
I suspect it is but I was looking for some feedback first.
I need to store the individual sales reps on a sales order in a separate table because Epicor stores them in a tilde delimited list in OrderHed.SalesRepList
I thought that using table triggers would be the best way.
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
addr: 37 Shuman Ave | Stoughton | Ma | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring
[cid:0ab8c4.png@70af9cdb.47ae9545]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
[Non-text portions of this message have been removed]