!!! SOFTWARE 4 SALE !!!?????????????????????????????????????????????????????????????????????? 51157
Saturday, 10 Nov 2007 19:38:48 -0600
Software for sale. Huge Selection. 10 Euros/CD. Worldwide shipping.
Windows, Mac, and Linux. The very latest software, stock video/photo, games, etc.
Contact David for details:
david007@worldnewstonight.net
...
|
Error
Fri, 9 Nov 2007 07:18:02 -0800
I have full text catalog on my table.
SELECT TOP 10 * FROM MyTable My(NOLOCK)
WHERE CONTAINS My.*, '"a.b.c.d*"')
query execute error;
"Msg 9937, Level 16, State 5, Line 1
Too many full-text columns or the full-text query is too complex to be
executed."
otherwise another query which doesn't have --"--
...
|
FTS user errors that I can't replicate!
Fri, 09 Nov 2007 02:39:53 -0000
I'm logging error messages for my ASP.NET application with errors
being emailed to me as they occur.
I continuosly get messages from one of my search pages that uses FTS
with "Execution of a full-text operation failed. A clause of the query
contained only ignored words". I've taken out all words out of the
dict ...
|
Advanced express deployment project question
Thu, 08 Nov 2007 13:31:24 -0700
I have a vs2005 deployment project and have set prerequisites to include sql express. This is not what I need however since I need the advanced version with full text search.
How can I make sure that the advanced version of sql express is installed when my app is installed?
Is there any way to include the setu ...
|
Dash in search string
Thu, 8 Nov 2007 09:50:03 -0800
Is it posible that dashes "-" are considering as punctuation when using
CONTAINSTABLE function? It's the behavior I see but I cannot find any text in
BOL that specify this.
This gives lots of rows:
SELECT k.KEY, * FROM ContainsTable(Request,*,N'ISSI-2007-0')
This gives no of rows:
SELECT k.KEY, * FROM Co ...
|
LIKE vs. FTS Results
Thu, 8 Nov 2007 07:28:04 -0800
Hi guys!
Hard to find exactly the definition of what I'm looking for in BOL. Let's
explain by example:
This return one row:
SELECT * FROM ContainsTable(Request,*,N'ISSI-2007-01001')
This return no row:
SELECT * FROM ContainsTable(Request,*,N'ISSI-2007-0100')
By using a LIKE with appropriate columns ( ...
|
Full text ranking not accurate after table update
Wed, 7 Nov 2007 12:53:01 -0800
I have setup a full text catalog on a table that contains both varchar & text
columns. After I update a record in the table the ranking of a particular
key is different than before the update even when the record is updated with
the original data. In other words, if I update one field in the record with
th ...
|
|
|
Contains clause with only NOT keywords
Wed, 7 Nov 2007 08:34:03 -0500
Hello everyone,
I posted this on sqlserver.programming and it was recommended I try this
group.
I am designing a search screen that searches for keywords in Text fields as
well as searching other related tables with fields like Date ranges and
other lookup code fields. One of our users asked why they can't ...
|
FTS - Support Services
Tue, 6 Nov 2007 15:10:25 -0600
I just added the FTS component and for some reason I don't see FTS in
Enterprise manager. All SQL services are running under the same account.
Any help would be appreciated.
Thanks
...
|
Error '0x80040e09' during indexing when connected to the network
Tue, 06 Nov 2007 05:06:42 -0800
Hi,
I've a strange problem. I use SQL Server 2005 Express edition and I've
setup a full text search system on my portable (this means that I'm
using the SQL Server instance an the FT catalog locale on my machine).
When I'm not connected to the network the indexing is working great.
When I shutdown the portabl ...
|
