Proc | dbatools | Command-line superpowers for SQL Server automation

Find-DbaStoredProcedure

Stephen Bennett, sqlnotesfromtheunderground.wordpress.com

Find-DbaStoredProcedure View Source Stephen Bennett, sqlnotesfromtheunderground.wordpress.com Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Searches stored procedure definitions for specific text patterns or regex expressions across SQL Server databases. Description Searches through stored procedure source code to find specific strings, patterns, or regex expressions within the procedure definitions. This is particularly useful for finding hardcoded values, deprecated function calls, security vulnerabilities, or specific business logic across your database environment.

Get-DbaDbStoredProcedure

Klaas Vandenberghe (@PowerDbaKlaas)

Get-DbaDbStoredProcedure View Source Klaas Vandenberghe (@PowerDbaKlaas) Windows, Linux, macOS On this page: Synopsis · Description · Syntax · Examples · Parameters · Outputs Synopsis Retrieves stored procedures from SQL Server databases with detailed metadata and filtering options Description Retrieves stored procedures from one or more SQL Server databases, returning detailed information including schema, creation dates, and implementation details. This function helps DBAs inventory stored procedures across instances, analyze database objects for documentation or migration planning, and locate specific procedures by name or schema.