• Sorry, edited my post.

    I think it is for information because when I script a disabled constraint then the follow up alter table has NOCHECK.

    Maybe someone who coded the scripting feature in SSMS decided that it was too much hassle to only script out the disable script if the constraint is disabled, and hence scripts it out for all.

    Catch-all queries done right [/url]
    Gail Shaw's Performance Blog[/url]