As far as the parameters go, I'm used to having to pass parameters to my SP's for other purposes. True when I run the SP I leave all at...

Thank you both.

I'm obviously more of a Joe than a Pro at this point. I combined the multiple lookups and I can now run the SP without issue.

Post mortem...

Thanks for the response.

When tracing using SQL Server Profiler and template TSQL_SPs the initial event I get is:

exec sp_executesql N'SELECT

SCHEMA_NAME(sp.schema_id) AS [Schema],

sp.name AS [Name]

FROM

sys.all_objects AS sp

WHERE

(sp.type = @_msparam_0 OR sp.type...