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 |
|
lilinikco
Starting Member
28 Posts |
 Posted - 2010-12-05 : 05:41:51
|
| hi all.I have a few tables and I defined on some foreign keys with ON update CASCADEproblem is that I'm getting an error that "it may cause cycles or multiple paths" and solve this by trigger wich updates fk in other tables.but now,we want delete this trigger and replace other solution,becouse managing of trigger is difficult.please guide me how to solve this problem?thankslili@@ |
|
|
|
|
|
solution of cycles or multiple cascade paths