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 |
|
skiabox
Posting Yak Master
169 Posts |
 Posted - 2009-07-09 : 21:28:06
|
| I am trying to set a foreign key constraint to a table but I get this error.The foreign key is an identity(1,1) primary key in its parent table.Any ideas?Thank you very much! |
|
|
skiabox
Posting Yak Master
169 Posts |
Posted - 2009-07-09 : 21:29:48
|
| setting ON UPDATE NO ACTION instead of ON UPDATE CASCADE seems to solve the problem |
 |
|
|
|
|
|
'may cause cycles or multiple cascade paths' error