The Ultimate Precompiled Procedure Searcher

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Lee Diggins SSC-Addicted Points: 467 More actions · Answer 1

Hey Jesse

Very nice, save me having to build a help file to do the searching for all those forgotten bits 😎

Lee

ChrisTaylor SSCarpal Tunnel Points: 4527 More actions · Answer 2

Good script if you only have one database in your system, what if you didn't know what database it existed on???

A loop through all none system sys.databases would be an good advancement on this!

_________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie

ecocarlisle SSC Enthusiast Points: 131 More actions · Answer 3

I copied the script into SQL Server 2005 and received several errors. Here is one of them:

The multi-part identifier "objects.object_id" could not be bound

Thoughts?

YeshuaAgapao Hall of Fame Points: 3495 More actions · Answer 4

Only works on SQL 2005. Also Check the compatibility level of the database.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 5

SSC Guru

Points: 76202

May 23, 2016 at 4:53 pm

Thanks for yet another good script.