Folks,
Just a quick one. How do you determine the user that the full text
service is using on SQL Server 2000? Any suggestions/code sample
diagnostics much appreciated.
Thanking you,
Al.
It has to use a local system account. If you have it run under a user
account it will not work.
On Dec 13, 6:21 am, "almu...@.altavista.com" <almu...@.altavista.com>
wrote:
> Folks,
> Just a quick one. How do you determine the user that the full text
> service is using on SQL Server 2000? Any suggestions/code sample
> diagnostics much appreciated.
> Thanking you,
> Al.
2012年3月29日星期四
2012年3月27日星期二
Full text search txt or doc files?
Hi,
I'm putting together a system and one of the requirements is to have a
searchable CV function.
I've got all the code to load the files on to the image fields, I've indexed
and got it mostly working.
Before I go to far down the road what is your opinion on having txt files
instead of doc files to search? The SQL seems to be more flexible on
searches rather than on the binary files and the index files themselves are
smaller.
My main concern is I'd have to do the text conversion automatically, any
pointers on this?
Does anyone have any views on the best way to go about this
Many thanks for any help you can give
Jim FlorenceHave you tried asking this in the sqlserver.fulltext news group?
As long as all expected binary types are supported by appropriate IFilters
on your server, using binary data will be just fine - AFAIK.
ML
http://milambda.blogspot.com/|||Thanks for the pointer, embarrassingly I didn't see it existed :0/
I just noticed on trying one query with "select like" it would only work on
varchar fields and failed on the blob, could well be mistaken though.
Thanks again
Jim
"ML" <ML@.discussions.microsoft.com> wrote in message
news:45DBD971-2EE7-42C5-AD3A-C3F542B4F8DA@.microsoft.com...
> Have you tried asking this in the sqlserver.fulltext news group?
> As long as all expected binary types are supported by appropriate IFilters
> on your server, using binary data will be just fine - AFAIK.
>
> ML
> --
> http://milambda.blogspot.com/|||The LIKE operatoron binary values works if the searched string is cast to
binary or varbinary, but only if the binary column contains a true
representation of the text, which is not how Word documents are represented.
What exactly did you try?
BTW: with FTI you really shouldn't use the LIKE operator - FTS functions are
more efficient in this case.
ML
http://milambda.blogspot.com/|||Thaks for thatr I knew I'd have missed something obvious.
I'm not entierly sure what the difference is between FTI and FTS, I thought
they were one and the same
Jim
"ML" <ML@.discussions.microsoft.com> wrote in message
news:29D91E26-BE4C-4832-B888-8FA47423C793@.microsoft.com...
> The LIKE operatoron binary values works if the searched string is cast to
> binary or varbinary, but only if the binary column contains a true
> representation of the text, which is not how Word documents are
> represented.
> What exactly did you try?
> BTW: with FTI you really shouldn't use the LIKE operator - FTS functions
> are
> more efficient in this case.
>
> ML
> --
> http://milambda.blogspot.com/|||Jim,
I am trying to do something similar. I have a list of .doc files that I am
trying to do i full text search on. I would really appreciate some help on
how to do this. Some sql code would be great. Thanks
qtrsteve@.yahoo.com|||Sorry for a late reply.
FTS = full-text search
FTI = full-text index
FTS uses FTI.
I was referring to FTS functions: contains, containstable, frettext,
freetexttable. FTS functions are far more efficient than the LIKE operator,
or at least the processing overhead of FTS is pretty constant compared to th
e
overhead when using the LIKE operator.
ML
http://milambda.blogspot.com/sql
I'm putting together a system and one of the requirements is to have a
searchable CV function.
I've got all the code to load the files on to the image fields, I've indexed
and got it mostly working.
Before I go to far down the road what is your opinion on having txt files
instead of doc files to search? The SQL seems to be more flexible on
searches rather than on the binary files and the index files themselves are
smaller.
My main concern is I'd have to do the text conversion automatically, any
pointers on this?
Does anyone have any views on the best way to go about this
Many thanks for any help you can give
Jim FlorenceHave you tried asking this in the sqlserver.fulltext news group?
As long as all expected binary types are supported by appropriate IFilters
on your server, using binary data will be just fine - AFAIK.
ML
http://milambda.blogspot.com/|||Thanks for the pointer, embarrassingly I didn't see it existed :0/
I just noticed on trying one query with "select like" it would only work on
varchar fields and failed on the blob, could well be mistaken though.
Thanks again
Jim
"ML" <ML@.discussions.microsoft.com> wrote in message
news:45DBD971-2EE7-42C5-AD3A-C3F542B4F8DA@.microsoft.com...
> Have you tried asking this in the sqlserver.fulltext news group?
> As long as all expected binary types are supported by appropriate IFilters
> on your server, using binary data will be just fine - AFAIK.
>
> ML
> --
> http://milambda.blogspot.com/|||The LIKE operatoron binary values works if the searched string is cast to
binary or varbinary, but only if the binary column contains a true
representation of the text, which is not how Word documents are represented.
What exactly did you try?
BTW: with FTI you really shouldn't use the LIKE operator - FTS functions are
more efficient in this case.
ML
http://milambda.blogspot.com/|||Thaks for thatr I knew I'd have missed something obvious.
I'm not entierly sure what the difference is between FTI and FTS, I thought
they were one and the same
Jim
"ML" <ML@.discussions.microsoft.com> wrote in message
news:29D91E26-BE4C-4832-B888-8FA47423C793@.microsoft.com...
> The LIKE operatoron binary values works if the searched string is cast to
> binary or varbinary, but only if the binary column contains a true
> representation of the text, which is not how Word documents are
> represented.
> What exactly did you try?
> BTW: with FTI you really shouldn't use the LIKE operator - FTS functions
> are
> more efficient in this case.
>
> ML
> --
> http://milambda.blogspot.com/|||Jim,
I am trying to do something similar. I have a list of .doc files that I am
trying to do i full text search on. I would really appreciate some help on
how to do this. Some sql code would be great. Thanks
qtrsteve@.yahoo.com|||Sorry for a late reply.
FTS = full-text search
FTI = full-text index
FTS uses FTI.
I was referring to FTS functions: contains, containstable, frettext,
freetexttable. FTS functions are far more efficient than the LIKE operator,
or at least the processing overhead of FTS is pretty constant compared to th
e
overhead when using the LIKE operator.
ML
http://milambda.blogspot.com/sql
2012年3月26日星期一
full text search on multiple tables yielding one rank
Is it possible to do full text search on multiple tables and having one rank
for all searches? Ive read a lot of articles that gives me code samples on
doing FTS on multi tables but they gave me multiple ranks for each search.
Without consolidating all of your data in the multiple tables into a child
table there is no way to do this with a meaningful rank.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"surigaonon" <surigaonon@.discussions.microsoft.com> wrote in message
news:28625427-A482-40B3-991B-BC7C35501801@.microsoft.com...
> Is it possible to do full text search on multiple tables and having one
> rank
> for all searches? Ive read a lot of articles that gives me code samples on
> doing FTS on multi tables but they gave me multiple ranks for each search.
sql
for all searches? Ive read a lot of articles that gives me code samples on
doing FTS on multi tables but they gave me multiple ranks for each search.
Without consolidating all of your data in the multiple tables into a child
table there is no way to do this with a meaningful rank.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"surigaonon" <surigaonon@.discussions.microsoft.com> wrote in message
news:28625427-A482-40B3-991B-BC7C35501801@.microsoft.com...
> Is it possible to do full text search on multiple tables and having one
> rank
> for all searches? Ive read a lot of articles that gives me code samples on
> doing FTS on multi tables but they gave me multiple ranks for each search.
sql
Full text search microsoft index server on .NET using C#
Hi,
I used the following code for an index search on specific folder.
{
//create a connection object and command object, to connect the Index
Server
System.Data.OleDb.OleDbConnection odbSearch = new
System.Data.OleDb.OleDbConnection( "Provider=\"MSIDXS\";Data
Source=\"SearchFolder\";");
System.Data.OleDb.OleDbCommand cmdSearch = new
System.Data.OleDb.OleDbCommand();
//assign connection to command object cmdSearch
cmdSearch.Connection = odbSearch;
//Query to search a free text string in the catalog in the contents of
the indexed documents in the catalog
string searchText = txtSearch.Text.Replace("","");
cmdSearch.CommandText = "select doctitle, filename, vpath, rank,
characterization from scope() where FREETEXT(Contents, "+ searchText
+") order by rank desc ";
odbSearch.Open();
I m able to get the TEXT search results. But full text search results
are reqiuired... like suppose if i search for experts release then i
need to get those documents where both the words exists..not only one
word.
Please let me know how to do this on .NET using C#.
Awaiting for the response.
Regards,
Rojasri.
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/Full-Text-se...ict228634.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=790451
use a contains based search for this.
ie
//Query to search a free text string in the catalog in the contents of
the indexed documents in the catalog
string searchText = txtSearch.Text.Replace("'","''");
cmdSearch.CommandText = "select doctitle, filename, vpath, rank,
characterization from scope() where CONTAINS(Contents, '"+ searchText
+"') order by rank desc ";
BTW - this is an indexing services question. It should be posted in
Microsoft.public.inetserver.indexserver
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"rojasree" <UseLinkToEmail@.dbForumz.com> wrote in message
news:4_790451_42f97e43956785fa721f58da989a05d8@.dbf orumz.com...
> Hi,
> I used the following code for an index search on specific folder.
> {
> //create a connection object and command object, to connect the Index
> Server
> System.Data.OleDb.OleDbConnection odbSearch = new
> System.Data.OleDb.OleDbConnection( "Provider=\"MSIDXS\";Data
> Source=\"SearchFolder\";");
> System.Data.OleDb.OleDbCommand cmdSearch = new
> System.Data.OleDb.OleDbCommand();
> //assign connection to command object cmdSearch
> cmdSearch.Connection = odbSearch;
> //Query to search a free text string in the catalog in the contents of
> the indexed documents in the catalog
> string searchText = txtSearch.Text.Replace("'","''");
> cmdSearch.CommandText = "select doctitle, filename, vpath, rank,
> characterization from scope() where FREETEXT(Contents, '"+ searchText
> +"') order by rank desc ";
> odbSearch.Open();
>
> I m able to get the TEXT search results. But full text search results
> are reqiuired... like suppose if i search for 'experts release' then i
> need to get those documents where both the words exists..not only one
> word.
> Please let me know how to do this on .NET using C#.
> Awaiting for the response.
> Regards,
> Rojasri.
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL:
http://www.dbforumz.com/Full-Text-se...ict228634.html
> Visit Topic URL to contact author (reg. req'd). Report abuse:
http://www.dbforumz.com/eform.php?p=790451
sql
I used the following code for an index search on specific folder.
{
//create a connection object and command object, to connect the Index
Server
System.Data.OleDb.OleDbConnection odbSearch = new
System.Data.OleDb.OleDbConnection( "Provider=\"MSIDXS\";Data
Source=\"SearchFolder\";");
System.Data.OleDb.OleDbCommand cmdSearch = new
System.Data.OleDb.OleDbCommand();
//assign connection to command object cmdSearch
cmdSearch.Connection = odbSearch;
//Query to search a free text string in the catalog in the contents of
the indexed documents in the catalog
string searchText = txtSearch.Text.Replace("","");
cmdSearch.CommandText = "select doctitle, filename, vpath, rank,
characterization from scope() where FREETEXT(Contents, "+ searchText
+") order by rank desc ";
odbSearch.Open();
I m able to get the TEXT search results. But full text search results
are reqiuired... like suppose if i search for experts release then i
need to get those documents where both the words exists..not only one
word.
Please let me know how to do this on .NET using C#.
Awaiting for the response.
Regards,
Rojasri.
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/Full-Text-se...ict228634.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=790451
use a contains based search for this.
ie
//Query to search a free text string in the catalog in the contents of
the indexed documents in the catalog
string searchText = txtSearch.Text.Replace("'","''");
cmdSearch.CommandText = "select doctitle, filename, vpath, rank,
characterization from scope() where CONTAINS(Contents, '"+ searchText
+"') order by rank desc ";
BTW - this is an indexing services question. It should be posted in
Microsoft.public.inetserver.indexserver
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"rojasree" <UseLinkToEmail@.dbForumz.com> wrote in message
news:4_790451_42f97e43956785fa721f58da989a05d8@.dbf orumz.com...
> Hi,
> I used the following code for an index search on specific folder.
> {
> //create a connection object and command object, to connect the Index
> Server
> System.Data.OleDb.OleDbConnection odbSearch = new
> System.Data.OleDb.OleDbConnection( "Provider=\"MSIDXS\";Data
> Source=\"SearchFolder\";");
> System.Data.OleDb.OleDbCommand cmdSearch = new
> System.Data.OleDb.OleDbCommand();
> //assign connection to command object cmdSearch
> cmdSearch.Connection = odbSearch;
> //Query to search a free text string in the catalog in the contents of
> the indexed documents in the catalog
> string searchText = txtSearch.Text.Replace("'","''");
> cmdSearch.CommandText = "select doctitle, filename, vpath, rank,
> characterization from scope() where FREETEXT(Contents, '"+ searchText
> +"') order by rank desc ";
> odbSearch.Open();
>
> I m able to get the TEXT search results. But full text search results
> are reqiuired... like suppose if i search for 'experts release' then i
> need to get those documents where both the words exists..not only one
> word.
> Please let me know how to do this on .NET using C#.
> Awaiting for the response.
> Regards,
> Rojasri.
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL:
http://www.dbforumz.com/Full-Text-se...ict228634.html
> Visit Topic URL to contact author (reg. req'd). Report abuse:
http://www.dbforumz.com/eform.php?p=790451
sql
2012年3月9日星期五
Full Text Catalogs and Permission
Hi
When I create a full text catalog via sql code, does the account the sql server is running under need any special permissions, since some files are created?
Or is it just the same as running any other sql code?
Thanks
Hi.
User must have CREATE FULLTEXT CATALOG permission on the database, or be a member of the db_owner, or db_ddladmin fixed database roles.
Full Text Catalogs and Permission
Hi
When I create a full text catalog via sql code, does the account the sql server is running under need any special permissions, since some files are created?
Or is it just the same as running any other sql code?
Thanks
Hi.
User must have CREATE FULLTEXT CATALOG permission on the database, or be a member of the db_owner, or db_ddladmin fixed database roles.
订阅：
博文 (Atom)