View & search functions, procedures, triggers, & views on MS SQL Server. Requires the "View Definition" permission to view objects on a database.
USE [Database]
GO
GRANT VIEW DEFINITION TO [user]
GO
Demo: https://www.johnwbartlett.com/ProgramTree/
Utilizes Fancytree to display a tree of databases and objects on a Microsoft SQL Server to search via name or by code.
Typing in the "Filter Objects" field will allow you to search the object names.
Typing in the "Search Code" field will search the source code for any matches and will filter the objects to just those that were found.
Clicking on any object will display the code for it.
Note: The ColdFusion datasource should have the CLOB setting enabled for viewing procedures greater than 63,000 characters in size.