Cascade Delete Problems - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Cascade Delete Problems

Author

Topic

jesus4u
Posting Yak Master

204 Posts

Posted - 2003-07-12 : 12:02:49

I have 5 tables with this relationship.

http://www.polajenko.com/sharepics/definition.bmp

What I am trying to accomplish is this:

A Calendar is made up of the other 4 entities joined to it. But when I place a Cascade delete on the Staff table I get an error from SQL Enterprise.

http://www.polajenko.com/sharepics/error.bmp

Can anyone help me please?!

Thanks in advance...

jesus4u
Posting Yak Master

204 Posts

Posted - 2003-07-12 : 22:13:54

anyone!? please

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2003-07-13 : 07:48:26

What's the problem in here? Haven't you never met cyclic references?
Picture to yourself such army:

1) I am your boss;
2) you are John's boss;
3) John is my boss;

Then, I issue an order... When and who will execute the order?

- Vit

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources