• Hi San,

    Try to build script with sp_helptext 'procedure_name'. It resolves procedure's body to rowset.

    You can use cursor which will go through all procedures (which are in sysobjects table) and print only those which consist your table.

    Hope it helps,

    Cheers,

    Bartek