Sunday, February 19, 2012

Index / Search question

Is a full-text search the only way to find specific data in a table or
database? Can a full-text, indexed search scan an entire database instead of
individual tables?
Thanks!
--
Dave WNo, AFAIK thats no working, but you can use the script from Vysh.(even this
is not using any fulltext features, but extending your search all columns in
al tables):
http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Dave W" <DaveW@.discussions.microsoft.com> schrieb im Newsbeitrag
news:2E5175AB-9EDD-4D34-92A2-51E683161FF9@.microsoft.com...
> Is a full-text search the only way to find specific data in a table or
> database? Can a full-text, indexed search scan an entire database instead
> of
> individual tables?
> Thanks!
> --
> Dave W|||Thanks Jens! Your reply was exactly what I needed!
--
Dave W
"Jens Sü�meyer" wrote:
> No, AFAIK thats no working, but you can use the script from Vysh.(even this
> is not using any fulltext features, but extending your search all columns in
> al tables):
> http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm
>
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Dave W" <DaveW@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:2E5175AB-9EDD-4D34-92A2-51E683161FF9@.microsoft.com...
> > Is a full-text search the only way to find specific data in a table or
> > database? Can a full-text, indexed search scan an entire database instead
> > of
> > individual tables?
> >
> > Thanks!
> > --
> > Dave W
>
>

No comments:

Post a Comment