• REALLY crammed with work this morning so didn't have time to set up a test or investigate, but is it possible to have 2+ tables with the same name belonging to different schemas each with a constraint named the same?

    Test.MyTable(MyDefaultConstraint)

    QA.MyTable(MyDefaultConstraint)

    Dev.MyTable(MyDefaultConstraint)

    And if that is possible (which one would think it could be if all 3 parts are considered in "uniqueness" of a constraint object) I think all we would have a problem with some if not all of the article code.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service