Skip to content

Instantly share code, notes, and snippets.

@arekgotfryd

arekgotfryd/Search for stored procedure by name among all databases on particular sql server

Created May 12, 2020 10:10
Show Gist options
  • Save arekgotfryd/736cc0ed7edf16c11259cf9b0f3b8bd6 to your computer and use it in GitHub Desktop.
Save arekgotfryd/736cc0ed7edf16c11259cf9b0f3b8bd6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Search for stored procedure by name among all databases on particular sql server
EXEC sp_msforeachdb
'if exists(select 1 from [?].sys.objects where name=''PBS_GenerateReport_sp'')
select ''?'' as FoundInDatabase from [?].sys.objects where name=''PBS_GenerateReport_sp'''
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment