Solved

Best full database search tool for SQL Server

Posted on 2016-09-12
4
37 Views
Last Modified: 2016-09-12
Hi - Can anyone recommend a tool for performing a database-wide, single entry field search, a-la Google, for SQL Server?
Thanks,
Steve
0
Comment
Question by:tablaFreak
  • 2
4 Comments
 
LVL 69

Accepted Solution

by:
Éric Moreau earned 500 total points
ID: 41794481
in SQL, this feature is known as the Full Text Search
0
 
LVL 39

Expert Comment

by:lcohan
ID: 41794495
"...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.
0
 
LVL 69

Expert Comment

by:Éric Moreau
ID: 41794497
0
 

Author Closing Comment

by:tablaFreak
ID: 41794550
Thanks, Éric!
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now