Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Lennartb
Starting Member
5 Posts |
 Posted - 2004-11-18 : 11:51:29
|
| Hi,I have a small question, normalwise a trigger is transactional. Is it possible to create a trigger, or give a command that the trigger isn't transactional? so that my inserted and deleted records are still available but the records which i lock in the trigger (for example a large update) are not transactionally updated...I hope someone has a solution for me. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-11-18 : 11:53:18
|
| Nope. All updates are logged.What exactly are you trying to do? |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-11-18 : 12:05:20
|
| He wants to avoid filling up the log...best to do mass updatyes in smaller batches...Brett8-) |
|
|
|
Lennartb
Starting Member
5 Posts |
Posted - 2004-11-19 : 05:57:46
|
| We have some problems with cascading triggers and datalocks from the front end application. That's because of the transaction. The transaction holds an exclusive lock over the records modified within the trigger, that's our problem and for our application that's not necessary.... |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-11-19 : 07:32:18
|
| Is the transaction required? Are the triggers required? Could the application or DB code be changed to use stored procedures that do all of the work? That would allow you to use transactions where needed, and not where they aren't. |
|
|
|
Lennartb
Starting Member
5 Posts |
Posted - 2004-11-20 : 04:45:10
|
| Actually, the triggers are required. A lot of the application consists out of stored procedures. But some triggers have to be fired, it is a workflow system. For example:- When I create one type of workflow, 2 others need to be created... Changing the standard software is not an option because of updates (Exact E-synergy application) So an SP is not an option because of the delay... |
|
|
|
|
|
|
SQL Triggers --> Not transactional