Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

The Ultimate Precompiled Procedure Searcher Expand / Collapse
Author
Message
Posted Saturday, June 21, 2008 10:59 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, October 21, 2013 4:37 PM
Points: 701, Visits: 211
Comments posted to this topic are about the item The Ultimate Precompiled Procedure Searcher


Post #521272
Posted Friday, August 29, 2008 1:39 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, February 7, 2012 3:24 AM
Points: 31, Visits: 48
Hey Jesse

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

Lee
Post #561020
Posted Thursday, October 30, 2008 3:46 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 4:30 PM
Points: 398, Visits: 1,735
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!


Chris

Blog:- chrisjarrintaylor.co.uk
Twitter:- @SQLGeordie
Post #594165
Posted Thursday, October 8, 2009 8:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 3, 2010 1:37 PM
Points: 3, Visits: 20
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?
Post #800036
Posted Thursday, October 8, 2009 10:19 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, October 21, 2013 4:37 PM
Points: 701, Visits: 211
Only works on SQL 2005. Also Check the compatibility level of the database.


Post #800169
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse