How can we help you today? How can we help you today?

Circular dependency warning in SQL Packager

I am trying the new SQL Packager. So far it has been very impressive. Anyway, when I do the scripting of one of our databases, I get this warning:
Data SQL Warnings
Circular dependency for the table or view [dbo].[tableA]

Circular dependency for the table or view [dbo].[tableB]

I think I almost guess what it means, but but so far I could not find if it is a serious problem or if there is a solution for it.

Sorry if this has been answered somewhere else. I did a search in online help and here in the forums and could not find anything.

Thank you.
diegov
0

Comments

4 comments

Sort by
  • richardjm
    There was a bug in the beta code that falsely claimed there to be circular dependencies. This was to so with forwards and backwards references being stored for triggers. This meant any table with a trigger on it that referenced the triggered table counted as circular. Kudos to you for spotting it.

    Thanks
    richardjm
    0
  • diegov
    Thanks Richard. Just for confirmation I will post tomorrow if I cannot repro with the new bits on the same database.
    diegov
    0
  • diegov
    Well, I can confirm that it worked. No more circular dependencies warning on RC1.
    diegov
    0
  • richardjm
    Brilliant, thanks for that.

    :)
    richardjm
    0

Add comment

Please sign in to leave a comment.