Summary


Triggers are excellent tools for a developer to have when building a database solution. Care has to be taken that the right trigger and the right code is placed within a trigger though. But the skill lies in knowing when to have cascading triggers, whether to work with transactions within a trigger, what to do when replication is involved, and what isolation levels to have.

Once a database solution is in place with working triggers, any alteration to that database environment, such as replication, will require a great deal of thought and planning. Testing should be intensive with an emphasis placed on areas such as performance. We may need to alter what happens within triggers, and maybe even split an AFTER trigger on one table action into two, with only one working on the replication.




SQL Server 2000 Stored Procedures Handbook
SQL Server 2000 Stored Procedures Handbook (Experts Voice)
ISBN: 1590592875
EAN: 2147483647
Year: 2005
Pages: 100

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net