StoredProcedure

Find-DbaStoredProcedure

Stephen Bennett, sqlnotesfromtheunderground.wordpress.com

Find-DbaStoredProcedure View Source Stephen Bennett, sqlnotesfromtheunderground.wordpress.com Windows, Linux, macOS 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. The function examines the actual T-SQL code stored in sys.

Get-DbaDbStoredProcedure

Klaas Vandenberghe (@PowerDbaKlaas)

Get-DbaDbStoredProcedure View Source Klaas Vandenberghe (@PowerDbaKlaas) Windows, Linux, macOS 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. You can filter results by database, schema, or procedure name, and exclude system stored procedures to focus on user-defined objects.

Get-DbaModule

Brandon Abshire, netnerds.net

Get-DbaModule View Source Brandon Abshire, netnerds.net Windows, Linux, macOS Synopsis Retrieves database modules (stored procedures, functions, views, triggers) modified after a specified date Description Queries sys.sql_modules and sys.objects to find database modules that have been modified within a specified timeframe, helping DBAs track recent code changes for troubleshooting, auditing, or deployment verification. Essential for identifying which stored procedures, functions, views, or triggers were altered during maintenance windows or after application deployments.