In SQL Search, provide the ability to exclude searching in comments for specified text
Periodically I'll search stored procedure and functions for specific text and I'll get a lot of hits, only to discover that the hit was on a comment.
For example if we're trying to remove a specific piece of code from all stored procedures, a DBA may make a comment "Removed XXX from stored procedure". Providing the ability to "Not search in comments" would provide a true list of areas that contain the offending code.
Jeff Raines
shared this idea
-
Paul
commented
Not understanding why this hasn't been implemented yet. the original request/suggestion was 7 years ago.
-
Anonymous
commented
Looks there is another version of this request which has more votes. Best to consolidate votes there:
-
Kimberlin
commented
i was coming on here to suggest this very thing. This is especially useful when searching for more common words like "Customer". This could be littered through comments and skew results when looking for specific references.