About
Pricing
Community
Teams
Start Free Trial
Log in
tablaFreak
asked on
9/12/2016
Best full database search tool for SQL Server
Hi - Can anyone recommend a tool for performing a database-wide, single entry field search, a-la Google, for SQL Server?
Thanks,
Steve
Microsoft SQL Server
4
1
Last Comment
tablaFreak
8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Éric Moreau
9/12/2016
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
lcohan
9/12/2016
"...a-la Google, for SQL Server? "
That thing does not exists in SQL(and many other RDBMS database engines) as far as I'm aware. You would have to write code to search against each and any "text" like (char, varchar, nchar, etc) columns for the "word" or "phrase" you are looking for.
Éric Moreau
9/12/2016
FTS:
https://msdn.microsoft.com/en-us/library/ms142571.aspx
tablaFreak
9/12/2016
ASKER
Thanks, Éric!
Your help has saved me hundreds of hours of internet surfing.
fblack61
That thing does not exists in SQL(and many other RDBMS database engines) as far as I'm aware. You would have to write code to search against each and any "text" like (char, varchar, nchar, etc) columns for the "word" or "phrase" you are looking for.