From the GP Blogs: Using SQL Triggers; How to Perform Year-End Closings; Running Microsoft Office 2010

by Jared Berezin
published October 8, 2009

Proceed with Caution: Using SQL Triggers with Dynamics GP: Dynamics GP Land walks us through an actual example in which they chose to use triggers: "SQL database triggers are an interesting, powerful, and potentially dangerous tool. On the one hand, they offer the appealing ability to execute an SQL script automatically, whenever a change is made to a database table... On the other hand, triggers can be difficult to implement, debug, and manage, and can cause unintended consequences."

...

Requires FREE Membership to View

Login
Become a Member Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more, and it’s all FREE. You’ll also receive periodic email newsletters with the latest relevant articles and content updates.
About Jared Berezin
Jared Berezin serves as a contributing writer to MSDynamicsWorld.com. With combined interests in technology and science, Jared previously served as a writer for Dana-Farber Cancer Institute, drafting scientific narrative reports on the latest advancements in cancer research. Jared has also served as associate marketing specialist for International Data Corporation (IDC), a market research firm. In this position, he planned and executed strategic marketing initiatives for IDC's software and services research programs, and wrote outbound communications to the press, existing clients, and prospects. Jared also has experience working for several local newspapers in eastern Massachusetts. Jared graduated with honors from Colby College with a BA in English and creative writing.

Read full bio...