Hi,
I noticed that when MP_Review_Customizations runs (either manually in SMS or via the report) its missing some of our custom procedures. For example I know for a fact that a few of our Report SP's with a prefix of "LRP" are not showing up as output.
I took a look at the SP, and as far as I can tell it should be picking up any and every SP that starts with an "L"...
(OBJECT_NAME(id) like 'L%'
Yet its not picking some of our LRP_ procedures up.
Anyone have any ideas?
Porter Venn (San Francisco Opera)
That procedure is not meant to display all custom procedures, only those that have key terms like xref, n1n2, name2, street1, T_ADDRESS, T_EADDRESS, T_PHONE and T_CUST_ACTIVITY%CATEGORY somewhere in the text. Right above the code you quote is:
WHERE [text] LIKE @cur_like
@cur_like is a variable that represents the search term looked for in that iteration of the loop.
If you know that the procedure(s) missing from the report contain references to these columns or tables, then I'll repeat Anna's suggestion to open a help ticket so we may investigate further. Including a copy of a sample proc that you think should have been included would be helpful.