• For Objects of type P, RF, V, TR, FN, IF, TF, and R try this:

    SELECT * FROM sys.sql_modules

    Which gives you all you want to know. You will most likely want to examine the columns available in sql_modules and limit the amount of information returned.

    And save the output to a file for later examination. I have found it useful to save it finally as a word doc and then I can use the search features of word to find in a table/column or whatever is returned in more than one SP ...

    Good luck.

    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]