• I believe some care is needed if you are relying on the is_ms_shipped flag being set to 1 for all MS shipped procedures. I get a list of stored procedures which I think are diagramming procedures that are not user defined procedures.

    For example:

    sp_alterdiagram

    sp_creatediagram

    sp_dropdiagram

    sp_helpdiagramdefinition

    sp_helpdiagrams

    sp_renamediagram

    sp_upgraddiagrams

    There may be more.

    cheers

    Tony