Searching inside SQL Files

Posted Wednesday, March 07, 2007 5:59 PM by CumpsD
This post has been moved to http://blog.cumps.be/search-file-contents/
Filed under: ,

Comments

# re: Searching inside SQL Files

Wednesday, March 07, 2007 4:19 PM by BertG

isn't this going to slow down the search process quite a lot?

Plus.. what is a keyword doing in the SQL file?

# re: Searching inside SQL Files

Thursday, March 08, 2007 4:20 AM by Stephen Price

I checked my registry and that entry is already there. So i did a search for SELECT and got no hits in .sql files...

Good idea though...

# re: Searching inside SQL Files

Thursday, March 08, 2007 4:57 AM by CumpsD

Most likely it will have a bit of a performance hit, but it's a good trade off in my opinion. Windows is already using them, just check out the registry entries for .txt for example (it's the same plain text handler)

Secondly, what do you mean what is a keyword doing in a sql file? It's just a script :)

---

It might be that the Indexing service is responsible for making it work or not, I didn't investigate further since it works here ;)