January 15, 2020 at 4:10 am
#roastme? lol...kidding...
tl;dr: I wrote a proc that basically does the same thing as Redgate SQL Search. Just curious to see if anyone wants to look at it and maybe provide some feedback...
Disclaimer: I've been working on this proc off and on for years. It's something I regularly use tons of times per day, it has been a massive help to me in my daily tasks. I start with that because many people might (and regularly do) question why I wrote this when there are GUI's (such as Redgate SQL Search). There may (and are) better things out there...but I like using it, and it works for me...so, let me have this one 🙂 lol
Another big part of me starting this project was that it's a way of forcing me to work on various development tasks and learn new things. I started writing this when I was VERY new to SQL, so it's actually helped me learn quite a bit over the years.
Anyways...I thought maybe I would post it up here and see if anyone would be interested in playing around with it themselves, maybe look through the code to provide better ways to do things, or maybe even suggest some features I hadn't thought of.
Here's the file on GitHub:
https://github.com/chadbaldwin/SQL/blob/master/dbo.usp_SchemaSearch.StoredProcedure.sql
99.9% of the time I use it, this is what I run:
EXEC dbo.usp_SchemaSearch
@Search = 'SearchCriteria', @ANDSearch = NULL, @ANDSearch2 = NULL, @WholeOnly = 1
, @DBIncludeFilterList = NULL, @DBExcludeFilterList = NULL
, @SearchObjContents = 1, @FindReferences = 1
, @BaseFilePath = 'X:\Git\database'
, @SuppressErrors = 1
Here's the ReadMe I have posted on GitHub to give a description of its features....
January 16, 2020 at 5:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply