• GarethPhilpott

    So the crux of my post:

    What SQL should I be running to make it spit out the procs?

    Try this ... tested using SSMS -- with query output as text in new tab.

    Select ROUTINE_SCHEMA, ROUTINE_NAME, ROUTINE_DEFINITION

    From INFORMATION_SCHEMA.ROUTINES where ROUTINE_TYPE='PROCEDURE'

    AND ROUTINE_DEFINITION LIKE '%update%'

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]