We get a procedure list with the help of DMV like " Sys.objects & sys.parameters"

USE [SqlBank]

SELECT s.NAME StoreProcedure, p.NAME Parameter FROM SYS.PARAMETERS p
JOIN SYS.OBJECTS s on p.object_id=s.object_id
WHERE TYPE='P'
ORDER BY p.NAME

From the above query, we get Procedure name with parameters

Output

Thank you for reading the blog.

HostForLIFEASP.NET SQL Server 2019 Hosting