|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Not getting proper result using contains Posted by Raj Gandhi at 6/27/2007 6:36:06 AM I am a software developer and working on one of the client application where
Full text search is required.
Requirement:
The search should allow to use whild cards.....
Problem:
the full text search does not work for postfix terms.....
I have three rows in my table
1. Marketing
2. Ma...more >>
Too many results error Posted by Equality72521 at 6/26/2007 5:43:02 AM Hi,
I can't find this covered elsewhere in here, but apologies in advance if it
has already been done to death:
SQL 2000 SP4
I've created a single column full text index on a single table (proof of
concept, more coming later) and the CONTAINS search is giving me the error:
"Msg 7643,...more >>
Full Text index on a view. Posted by Lee at 6/22/2007 1:23:54 PM Am I missing something here? SQL Server 2005 BOL states that one the
requirements for the CREATE INDEX on a view are:
"The view cannot include text, ntext, or image columns, even if they
are not referenced in the CREATE INDEX statement".
But to create a Full Text index on the text column refer...more >>
Text tying too slow? Posted by Rachelle at 6/19/2007 12:00:00 AM While I am typing, for somr reason, I have to really type slow???? or it
will not type correct. Can anyone help me change my typing speed? [like
changing the speed of your coursor]..please help, if u know where I need to
go to do this, let me know.. It takes me 5-10 minutes to type this.
T...more >>
How to search a phrase inside a single DB field Posted by Fabio Gava at 6/15/2007 12:00:00 AM I have this problem: all the keywords of an image are stored in a single
text field called "keywords". I created a catalog on that field.
A couple of samples of my keywords:
ImageA = Tower Bridge, landmark, bridge, illuminated, National Famous Place,
Thames
ImageB = architecture, bell tow...more >>
Near Clause usage Posted by Brian at 6/13/2007 10:09:03 AM Two items:
Is there a way to limit the proximity of the two words in the NEAR clause to
less than 50 words in SQL Server 2005 when doing a Full Text search? I
believe the default is 50 words.
Also, I noticed when I do fulltext search over an xml type column I don't
get the exact words I m ...more >>
search problem after upgrade from SQL2000 SP3 / w2k to SQL2000 SP4 / w2k3 Posted by tbh at 6/13/2007 12:00:00 AM hi,
we have recently upgraded a production database using the following trick
(to minimize downtime):
- we replicated the database from db004 (old)[*] to db04 (new)[**] (merge
replication, updates every minute i think)
- [incidentally, i don't think it matters] we took this opportunity to
...more >>
Cannot Create Full-Text Catalog Posted by Ross Culver at 6/13/2007 12:00:00 AM I had a perfectly good FT catalog, but I was trying to repopulate it after
making changes to the noiseeng file. I restarted the Full-Text search
engine.
When I tried to run a full-text query against the table, I got this error
"no such interface supported". In the message there was a recomme...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Parsing Google-like queries for FT search Posted by Fabio Gava at 6/7/2007 12:00:00 AM I've successufully installed FT on a SQL Server 2000 used to manage images
database.
What I need now is a parser to translate "common use" query in FT correct
query, just to reduce the impact on web users on their searches on the site.
I guess I need something like:
http://ewbi.blogs.com/d...more >>
Problem with Full Text on New Cluster Nodes Posted by Pat Hall at 6/6/2007 7:05:03 PM Windows 2003 SP1 SQL 2000 SP3a active/passive cluster 24x7 cluster
used by customer facing apps.
Added a new node to the cluster and failed over. The Full Text Indexes on
my database are “goneâ€. If the resources are owned by the “old†node, I can
work with the Full Tex...more >>
Error occurred during full-text index population??? Posted by Jen Fields at 6/6/2007 11:21:01 AM Help! Any suggestions are most welcome.
I am trying to configure fulltext indexing to index MS Office files on SQL
Server. I am using an Access 2007 form with a SQL Server 2005 back end. The
SQL table is configured with a content field varbinary(max) and an extension
field varchar(10)
...more >>
pdf ifilter issue with sp_fulltext_service Posted by Dlorbecki at 6/6/2007 7:53:00 AM Several internet posts I've read describe how to get SQL Server to recognize
a 3rd party ifilter .dll. This involves the use of sp_fulltext_service with
the following syntax:
Exec sp_fulltext_service 'verify_signature', 0
Exec sp_fulltext_service 'load_os_resources', 1
I've used these co...more >>
pdf ifilter sp_fulltext_service settings dilemma Posted by Dlorbecki at 6/5/2007 1:41:00 PM I've read Mr. Cotter's article on full-text search and as with several other
folks, he mentions the use of the following commands to allow the adobe pdf
ifilter to be used.
exec sp_fulltext_service 'load_os_resources', 1;
exec sp_fulltext_service 'verify_signature', 0;
This works fine. H...more >>
Create FTC Permissions Posted by Andrew at 6/5/2007 12:38:00 AM Hi, I only know some basics about permissions on SQL 2005, I watched the
video on setting up FTCs (thanks for the link). On my server (Express Adv.
Ed. SP2 with everything installed) I created a login with dbcreator and
public permissions. The login can create and access the database (dbowner ...more >>
Still have stuck Pending Changes Posted by Kyle Jedrusiak at 6/4/2007 12:17:28 PM We have updated our server to the latest updates from MS.
We have a set of indexed views (21 in total). They are set to Track Changes
Automatically.
The problem is that they're not doing it. The pending changes are stuck in
limbo.
I have to individually turn the Track Changes Automati...more >>
Incremental scans entire table rather than only changed rows Posted by Ian Boyd at 6/3/2007 2:45:09 PM The table being indexed has only one changed row, but when i do an
incremental population the table is being hit millions of times (millions of
rows). The table has a timestamp column.
How can i make incremental population only index rows that have changed?
(i already know the answer -...more >>
ContainsTable returns "Informational: MS Search stop limit reached Posted by sql411 NO[at]SPAM nospam.com at 6/1/2007 10:48:00 AM When I run a containsTable search I get the following error:
Informational: MS Search stop limit reached. The full-text query may have
returned fewer rows than it should.
Error 9926 Severity 10
This is causing erratic results, I see nothing in the ft logs for this
catalog that indicat...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |