Object Search

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Sean Smith » Object Search

Object Search

Rate Topic

Display Mode

Topic Options

Author

Message

Sean Smith-776614

Posted Friday, May 01, 2009 11:49 AM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, May 19, 2013 2:19 PM
Points: 90, Visits: 369

Comments posted to this topic are about the item Object Search

Post #708637

Tim Edwards-235208

Posted Tuesday, July 03, 2012 3:27 PM

Forum 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

Sean Smith-776614

Posted Tuesday, July 03, 2012 4:00 PM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, May 19, 2013 2:19 PM
Points: 90, Visits: 369

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

Tim Edwards-235208

Posted Tuesday, July 03, 2012 5:10 PM

Forum 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

Sean Smith-776614

Posted Tuesday, July 03, 2012 5:36 PM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, May 19, 2013 2:19 PM
Points: 90, Visits: 369

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

Douglas Osborne-229812

Posted Thursday, October 18, 2012 6:31 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 6:58 AM
Points: 47, Visits: 168

I'm not clear if this will allow for searches within SSIS packages?

Post #1374292

Sean Smith-776614

Posted Thursday, October 18, 2012 11:15 AM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, May 19, 2013 2:19 PM
Points: 90, Visits: 369

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

« Prev Topic | Next Topic »

Permissions