MP_Review_Customizations SP not showing all SP's

Former Member
Former Member $organization

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)



[edited by: Porter Venn at 5:17 PM (GMT -6) on 23 Mar 2012]
Parents Reply Children
No Data