I found not enough functionality of "Business Rules" and would like to use Native MS SQL triggers to update some fileds

As example: Analyze some words in Subject and update Subject to other words, update Priority, Impact, etc.

What I'm interesting if only one table should be updated or there cascade of tables?

Dmitry