create event session [sqlproc_params_errors] on server
add event [sqlserver].[error_reported] (where [error_number] = 8144)

drop table if exists #err_procs;
create table #err_procs ([name] varchar(255), [msg] nvarchar(4000));


declare @sql nvarchar(max);
declare cur cursor local for
       select
             'begin try exec (''SET FMTONLY ON; EXEC ' + quotename(object_schema_name(o.[object_id])) + '.' + quotename(parsename(o.[name], 1)) + stuff(x.plist, 1, 1, '') + ''') end try begin catch insert into #err_procs ([name], [msg]) values (' + quotename(o.[name], char(39)) + ', ERROR_MESSAGE()); end catch;' 
       from sys.objects o
           cross apply (
                        select ',' + p.[name] + '=null'
                        from sys.parameters p
       		        where p.[object_id] = o.[object_id]
                        for xml path('')
       	               ) x(plist)
       where o.[type] = 'P'
         and o.[is_ms_shipped] = 0
         and o.[schema_id] <> 4;

open cur;
while 1 = 1 begin
     fetch next from cur into @sql;
	 if @@FETCH_STATUS <> 0 break;
	 exec (@sql);
end;
close cur;
deallocate cur;

select * from #err_procs