SQL Express Advanced
Wed, 18 Jun 2008 15:09:07 -0700 (PDT)
I have an instance of SQL Express 2005 with the Advanced Tools
installed on an XP machine. I can turn on full text in the DB
property window but there are no other nodes in the management studio
for full-text. There's no storage node or other menu/properties for
full-text. The fulltext service for this instan ...
|
error populating full text index.
Tue, 17 Jun 2008 20:52:02 -0700
I'm trying to populate a full text index on a database but I'm having some
troubles.
I've tried re-creating the index, re-populating it fully, and even
incrementally all to no avail. The full text catalog for this table still
says the item count is 0. Can anybody shed some light on this?
Here's what g ...
|
Full Text Index Eror - Corruption
Sat, 14 Jun 2008 08:31:01 -0700
Good Day,
I have noticed this warning in my SQL Server 2005 log. The full message
reads:-
Warning: Failed to get MSFTESQL indexer interface for full-text catalog
'JobsFullTextIndex' ('10') in database 'XXXXXXX' ('7'). Error: 0x80043613(A
status change is occurring or the project is in a force paused state, ...
|
MULtiple columns search using Containstable.
Fri, 13 Jun 2008 06:32:01 -0700
I have atable called Books and contains following columns all varchar(2000)
columns.
Title,Comments,Reference,PLaceprinted etc.
I want to search all these columns. for key word(s) entered by user.
if user enters in a key word(s) GUI field e.g: "New york"
right now i am using ASP as my front end and sq ...
|
Fulltext Indexing leaves a transaction open, preventing inserts on a
database
Wed, 11 Jun 2008 09:41:24 -0700 (PDT)
Hello,
Please read this two threads first, as this all started on .newusers
(I'm one of them)
More relevant: (http://tinyurl.com/454uav http://preview.tinyurl.com/454uav)
http://groups.google.com/group/microsoft.public.sqlserver.newusers/browse_thread/thread/682e346776184261/a7eb5ab7f9649cf6?#a7eb5ab7f9649c ...
|
Full-text search in not supported language (albanian)
Wed, 11 Jun 2008 16:00:40 +0200
Hello everyone,
I'm trying to implement full-text search for the albanian language. What's
the best way to implement it?
Based on my current understanding the most feasible way is to:
1. Use one of the supported lnaguages, for example Turkish.
2. Replace noisy words of Turkish with Albanian noisy words.
3. ...
|
full-text index with multiple tables
Thu, 5 Jun 2008 16:41:11 -0400
Hi All: I just stumbled across this post, noting that you can create a view
against multiple tables, and then use the view in the full-text index, so
that if you do a freetexttable query agains the view, you are in effect
searching multiple tables simulataneously.
http://versia.com/2008/02/06/sql-server-ful ...
|
|
|
What queries (NO GUI) do I give from start to finish for full-text
indexing?
Thu, 5 Jun 2008 07:02:55 -0700 (PDT)
From start to finish, what queries do I give to enable fulltext (if
not enabled), create catalog, create and populate index for a table?
I do not want to use any UI for this. I'm using SQL 2005.
Regards,
--Jaffar ...
|
How can I rename full text indexing file name
Wed, 4 Jun 2008 12:03:48 -0700 (PDT)
Can any one point me to right direction for renaming of full text
index file name. I have full text indexing on a table and I have to
rename this file without droping and receating full text indexing. For
example
SELECT name, physical_name
FROM sys.master_files
WHERE database_id = DB_ID('adventureworks');
...
|
FREETEXT / CONTAINS question
Wed, 28 May 2008 13:22:43 -0700 (PDT)
Hi, I am using the WITH FREETEXT command against my database.
The problem I am having is that the WITH FREETEXT treats seperate
words passed in using an OR
so instead of getting a search for 'Guitar AND Player AND America' I
am getting 'Guitar OR player OR America'
From looking around I can use the CO ...
|
