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 |
|
flagstaffroy
Starting Member
2 Posts |
 Posted - 2006-10-09 : 09:34:34
|
| I had a trigger that worked fine under sql server 7.After I have updated to ss2k, it now triggers multiple times and enters data in a secondary table.All things equal, could this be a recursive trigger problem?How do I set it to false?Roy |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-10-09 : 09:54:56
|
Really can't comment on why it is behaving this way, unless you post trigger code. You can set Recursive Triggers setting to OFF as follows:1.Expand a server group.2.Right-click a server, and then click Properties.3.Click the Server Settings tab.4.Under Server behavior, select or clear the Allow triggers to be fired which fire other triggers (nested triggers) check box. orsp_configure 'Using Nested Triggers', 0GORECONFIGUREGO Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
|
|
|
Recursive trigger problem?