C
Caroline
I have new users coming in and would like to add them into this pool,
but I have been
unable to, encountering an Update error in MS SQL with a check option
constraint.
someone suggested that there is a need to maintain consistency between
the
Web_Resources, Resources, and Calendar tables, other wise the system
will not
permit any additional resources to be added. The way to check is to
compare
these three tables in a query to see if there is one record that is
either
missing in one or more of the tables.
However, I am not sure what to look out for.
i.e. the field columns to compare etc.
Please elaborate and advise possible solutions.
Thanks in advance!
but I have been
unable to, encountering an Update error in MS SQL with a check option
constraint.
someone suggested that there is a need to maintain consistency between
the
Web_Resources, Resources, and Calendar tables, other wise the system
will not
permit any additional resources to be added. The way to check is to
compare
these three tables in a query to see if there is one record that is
either
missing in one or more of the tables.
However, I am not sure what to look out for.
i.e. the field columns to compare etc.
Please elaborate and advise possible solutions.
Thanks in advance!