Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Full-Text Search / June 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Not getting proper result using contains28 Jun 2007 23:23 GMT2
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.....
Full Text index on a view.25 Jun 2007 20:33 GMT6
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".
Text tying too slow?22 Jun 2007 00:55 GMT1
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 ...
Near Clause usage19 Jun 2007 14:50 GMT7
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.
How to search a phrase inside a single DB field15 Jun 2007 18:52 GMT4
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,
Error '0x8000ffff' occurred during full-text index population14 Jun 2007 17:46 GMT4
I have a nightly job scheduled by the SQL Agent scheduler to run full-text
creations nightly, and I have noticed that the following error message
appears during the process of trying to index a number of tables (but not
all).
search problem after upgrade from SQL2000 SP3 / w2k to SQL2000 SP4 / w2k314 Jun 2007 13:26 GMT4
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)
Parsing Google-like queries for FT search13 Jun 2007 20:07 GMT5
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.
Cannot Create Full-Text Catalog13 Jun 2007 14:36 GMT1
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
Create FTC Permissions12 Jun 2007 11:49 GMT1
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 ...
Error occurred during full-text index population???12 Jun 2007 11:44 GMT1
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
pdf ifilter sp_fulltext_service settings dilemma07 Jun 2007 20:37 GMT2
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;
pdf ifilter issue with sp_fulltext_service07 Jun 2007 20:33 GMT1
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
Incremental scans entire table rather than only changed rows06 Jun 2007 21:55 GMT2
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?
Still have stuck Pending Changes05 Jun 2007 13:38 GMT2
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
Pages: 1 2 May, 2007
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.