| Thread | Last Post | Replies |
|
| Not getting proper result using contains | 28 Jun 2007 23:23 GMT | 2 |
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 GMT | 6 |
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 GMT | 1 |
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 usage | 19 Jun 2007 14:50 GMT | 7 |
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 field | 15 Jun 2007 18:52 GMT | 4 |
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 population | 14 Jun 2007 17:46 GMT | 4 |
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 / w2k3 | 14 Jun 2007 13:26 GMT | 4 |
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 search | 13 Jun 2007 20:07 GMT | 5 |
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 Catalog | 13 Jun 2007 14:36 GMT | 1 |
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 Permissions | 12 Jun 2007 11:49 GMT | 1 |
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 GMT | 1 |
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 dilemma | 07 Jun 2007 20:37 GMT | 2 |
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_service | 07 Jun 2007 20:33 GMT | 1 |
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 rows | 06 Jun 2007 21:55 GMT | 2 |
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 Changes | 05 Jun 2007 13:38 GMT | 2 |
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
|