This SP takes a string to be searched as input parameter, loops through all tables, views, Sp-s in the database andreturns the name of the object it was found and number of occurences

5 (1)

2004-12-10 (first published: )

634 reads


SSAS Tabular – Process Add memory consumption


For me it’s a bit surprising how little information can be found regarding the...

Our SQL Server 2019 Administration Inside Out Fun Author Survey


SQL Server 2019 Administration Inside Out Honored again to be leading the talented SQL Server...

What's New in SQL 2019? at the Data Architecture Virtual User Group and Q&A followup


Thanks to all 180+ of you who joined the Data Architecture Virtual User Group...

Read the latest Blogs


BULK insert several thousand files

By MVDBA (Mike Vessey)

I have a bunch of logging data that my sysadmin has downloaded from our...

SSRS 2016 install on FCI with AAAG.

By snomadj

Appreciate advice here as I am slightly confused. I need to install SSRS 2016...

upgrade plan common sense check please

By snomadj

Be grateful for a yay or nay on my plan: 4 nodes. 2012.  1...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers