Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Object Search Expand / Collapse
Author
Message
Posted Friday, May 1, 2009 11:49 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, May 27, 2016 6:41 AM
Points: 414, Visits: 894
Comments posted to this topic are about the item Object Search
Post #708637
Posted Tuesday, July 3, 2012 3:27 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 10, 2013 7:32 AM
Points: 4, Visits: 366
I think it is worth noting that the @v_Search_String parameter should not contain any wildcards (i.e., %) as the stored procedure adds that to the parameter. I didn't realize that at first and was not getting anything back on my test system when I knew the string existed. Going through the code, I quickly discovered that the wildcards are added to the string in the parameter for you and my adding them caused it to read the wildcard as a literal character that was part of the search string.
Post #1324707
Posted Tuesday, July 3, 2012 4:00 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, May 27, 2016 6:41 AM
Points: 414, Visits: 894
When I originally designed the procedure it actually functioned the way you wanted it to. After a peer review with some colleagues, they all argued for the opposite (never can win it seems LOL). Since you've familiarized yourself with the code you should be able to adjust it to fit your needs.

Thanks for the feedback.
Post #1324730
Posted Tuesday, July 3, 2012 5:10 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 10, 2013 7:32 AM
Points: 4, Visits: 366
No problem. That works fine for me, just needed to figure it out and wanted to let everyone else know how to pass the search string parameter to the stored procedure so they don't run into the same thing.
Post #1324739
Posted Tuesday, July 3, 2012 5:36 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, May 27, 2016 6:41 AM
Points: 414, Visits: 894
Good idea and thanks for posting this. I may end up adding a "use or search" for wildcards switch in a later version. This would make it more flexible.
Post #1324741
Posted Thursday, October 18, 2012 6:31 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 24, 2016 2:05 PM
Points: 108, Visits: 318
I'm not clear if this will allow for searches within SSIS packages?
Post #1374292
Posted Thursday, October 18, 2012 11:15 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, May 27, 2016 6:41 AM
Points: 414, Visits: 894
Honestly, never tried (but I would think no). Sorry, haven't dealt much with SSIS packages. Try a search string that you know is in an SSIS package and see if it brings back any results. Post the results if you don't mind.
Post #1374512
Posted Friday, June 20, 2014 6:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 12:31 PM
Points: 1, Visits: 35
Hi, I am trying to search a string from the object definitions like this and getting no result

EXECUTE dbo.usp_Object_Search
@Search_String = N'fiscal/2'
,@Database_Name = N'Test'
,@Search_Against = 'D'

Above Test is my database name and fiscal/2 is the string in one of the stored procedures. Please help, this is looking awesome procedure if it work for my situation.
Thanks
Post #1584318
Posted Saturday, June 21, 2014 6:47 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, May 27, 2016 6:41 AM
Points: 414, Visits: 894
Moneer-479830 (6/20/2014)
Hi, I am trying to search a string from the object definitions like this and getting no result

EXECUTE dbo.usp_Object_Search
@Search_String = N'fiscal/2'
,@Database_Name = N'Test'
,@Search_Against = 'D'

Above Test is my database name and fiscal/2 is the string in one of the stored procedures. Please help, this is looking awesome procedure if it work for my situation.
Thanks


Is the database in question case sensitive?
Post #1584745
Posted Thursday, September 25, 2014 6:51 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 26, 2016 3:24 AM
Points: 151, Visits: 161
Does this procedure also pick up Indexes? It does not look like it in the Valid Object type list. How can I add Indexes to this search?
Post #1619686
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse