Skip to content

Instantly share code, notes, and snippets.

@shaneis

shaneis/FirstAttemptRegex.ps1

Last active May 25, 2018 15:53
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save shaneis/9038bb33358770f1b23ac516330e6500 to your computer and use it in GitHub Desktop.
Save shaneis/9038bb33358770f1b23ac516330e6500 to your computer and use it in GitHub Desktop.
Download ZIP
Attempt 1
Raw
FirstAttemptRegex.ps1
$PatternMatch = '(?<ColumnName>\w+)\s*=\s*@(?<ParameterName>\w+)'
$FindStoredProcedureParameters = @{
SqlInstance = 'localhost\SQLServer2K16'
Database = 'master'
Pattern = $PatternMatch
IncludeSystemDatabases = $true
}
Find-DbaStoredProcedure @FindStoredProcedureParameters
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment