How to find all DB Stored Procedures in HEAT Help Desk

Version 1

    Details

    Is there a way to find all the Stored Procedures in a database?


    Resolution

    Run the following query in SQL Server Management Studio replacing DB_NAME with the name of your database:

    USE DB_NAME

    SELECT * FROM sys.procedures