search_stored_procedures_by_content
Find stored procedures in SQL Server databases by searching for specific text or patterns within their SQL definitions to locate relevant database logic.
Instructions
Search for stored procedures containing specific text or patterns in their SQL definition
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connectionString | No | SQL Server connection string (uses default if not provided) | |
| connectionName | No | Named connection to use (e.g., 'production', 'staging') | |
| searchText | Yes | Text or pattern to search for in procedure definitions | |
| schema | No | Schema name (default: dbo) | |
| caseSensitive | No | Case sensitive search (default: false) | |
| includeDefinitions | No | Include full procedure definitions in results (default: false) |