Skip to content

Instantly share code, notes, and snippets.

@MarshalOfficial

MarshalOfficial/find-sps-that-contain-a-specific-word.sql

Created January 14, 2024 09:33
Show Gist options
  • Save MarshalOfficial/cd14f4ccaf226af129bb88ef4732b164 to your computer and use it in GitHub Desktop.
Save MarshalOfficial/cd14f4ccaf226af129bb88ef4732b164 to your computer and use it in GitHub Desktop.
Download ZIP
find all sps that contain specific word in sql server
Raw
find-sps-that-contain-a-specific-word.sql
SELECT OBJECT_NAME(object_id) AS Procedure_Name FROM sys.sql_modules(nolock) WHERE definition LIKE '%31291%' AND OBJECTPROPERTY(object_id, 'IsProcedure') = 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment