Wrong default constraint shown from Object Browser in Query Analyser

[jbtaylor16]

I have several default constraints defined on a table. When I use the
Object Browser and expand the constraints for this table and
right-click and then select "Script Object to New Window As Create", a
create constraint statement for a different default constraint is
displayed than the one I just right-clicked on. For example, I click
on constraint "DF_C" and it shows me "DF_B".

The last time I encountered this, the solution was to dump contents of
the table into another, drop, recreate it, and restore the contents.

That's not a good option this time.

Is there another way to fised this or at least navigate the catalog to
find out what is "off" about this?

Thanks

[Erland Sommarskog]

(jb********@fuse.net) writes:

I have several default constraints defined on a table. When I use the
Object Browser and expand the constraints for this table and
right-click and then select "Script Object to New Window As Create", a
create constraint statement for a different default constraint is
displayed than the one I just right-clicked on. For example, I click
on constraint "DF_C" and it shows me "DF_B".

The last time I encountered this, the solution was to dump contents of
the table into another, drop, recreate it, and restore the contents.

That's not a good option this time.

Is there another way to fised this or at least navigate the catalog to
find out what is "off" about this?

Try dropping all the constraints, and then recreate them. It's a little
difficult to say what is going on, as I cannot repro the situation.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp