|
|
|
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 |
Inter-word searching Posted by jst1699 at 7/31/2007 2:02:03 AM Hi,
Can you guys give me some tips on how to implement inter-word searching in
SS 2005 FTS or any non-FTS way (but has to be MS technology based - company
rules)
E.g. word - AstraZeneca
- doing FTS searching for Zeneca returns zero rows
- Astra* finds the row (OK)
I posted on
http://...more >>
Full Text catalog not working Posted by Alex H at 7/30/2007 10:18:10 PM Hi I am trying to create a Full Text Xatalog, but after entering the name, I
am getting an error message saying that The Microsoft Search Service cannot
be administered under the present user account.
I am administrator, and as far as i can see both SQL and MS Search are
running under the s...more >>
Help adding text to column with sql 2005 query Posted by astra14i NO[at]SPAM hotmail.com at 7/30/2007 3:25:38 PM Hi there,
I'm quit newby to this, so i'd like to have some help please.
I've a column whit some text where i want to insert more text before
and after, with sql 2005.
I'm trying this way, without success:
.....
update dbo.log
SET dbo.log.text = ('lot1' + dbo.log.text + 'lot2')
What sha...more >>
Full text index not tracking changes on an indexed view Posted by mbedser NO[at]SPAM gmail.com at 7/27/2007 9:54:59 AM We had a peculiar situation today where our lovely indexed view
obviously had textual data in it but some recently added rows were not
being returned in a CONTAINS query when they should have been.
Deleting and recreating the FT index fixed things immediately and I
can't seem to reproduce it but...more >>
Using DISTINCT and ORDER BY in the same query Posted by Nathan Sokalski at 7/26/2007 8:08:15 PM I have the following SQL statement:
SELECT field1 FROM table1 WHERE field2=25 ORDER BY field3
This statement works fine, but the results contain duplicates, because
field1 contains the same value in multiple records. I would have thought
that modifying the statement with the keyword DISTIN...more >>
Text Column Compare Posted by Benjamin at 7/25/2007 8:34:32 AM *also posted on microsoft.public.sqlserver*
Hello,
I am trying to do a text compare (case sensitive compare in sql server
2000) on a column of type text with a variable of type text. This
compare doesn't seem to be working as coded in the below code
segment. It worked when the variables w...more >>
freetexttable issue Posted by ibaldwinjr NO[at]SPAM gmail.com at 7/19/2007 12:00:00 AM Hi,
I am using freetexttable as a search tool for our application but it
seems that it is partially working. I am able to search on some words
specified in my catalog but not on others. For example I got keywords
- stamps business cards. The freetexttable function can pick up only
'stamps' bu...more >>
Searching on # Posted by Mike at 7/18/2007 12:32:07 AM Hi,
I have 2 identical sql 2000 servers with full text indexing enabled on both.
I have the same data structure etc however on one sql server I can run SELECT
* FROM tblTest WHERE CONTAINS(text,"'C#'") and get results however running on
the second I get a message saying the query contains n...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
FULL TEXT SEARCH AND RECORD NUMBER PROBLEM Posted by in da club at 7/17/2007 12:00:00 AM I dynamically create my query based on filter criteria , order by criteria
and paging criterias. I have no promlem at that point.
My problem is that How can i get total record number of my recordset in
stored procedure. What is the best way to get it. Should i use and output
parameter in st...more >>
Syntax Question: Query by File Extension Posted by Jack at 7/12/2007 12:00:00 AM In my catalog of photos the following query returns all jpegs
(correct):
#filename *.jpg
And this returns 1 result (correct)
#filename *.jpeg
However this returns nothing (incorrect):
#filename *.|(jpeg|,jpg|)
....unless I add another filename query (correct):
#filename *.|(jpeg|,jpg|) AND @...more >>
Full Text Index not working when populated from nvarchar. Bug? Posted by gavin at 7/11/2007 2:50:03 PM Hi, I was wondering if any SQL Server gurus out there could help me...
I have a table I'm trying to apply a full text catalog to, however no
results are ever returned due to the text column being cataloged being of
varbinary(max) that's being populated from a converted nvarchar(max) value.
...more >>
SQL Server 2000 Full Text Search Not Returning Expected Results Posted by Craig Stewart at 7/9/2007 8:56:03 AM I support an application that uses full text indexes in SQL Server 2000. I'm
trying to resolve an issue where by the results of a search in the production
application do not include the expected results. I've been unable to
reproduce the scenario in my development environment.
Both the pr...more >>
unexpected behavior with certain words "i" Posted by Thorsten Jakobsson at 7/9/2007 2:38:02 AM Hello,
I have started to test fulltext indexing. I have run into a problem that I
don't know how to solve.
I have this data in one fulltext-column "Landsorganisationen i Sverige".
When I perform this search I get 1 hit:
select top 100 * from CA_CATALOG_New_SEARCH where
CONTAINS(FWD_ALL,'"la...more >>
Update to SP4 causes starnge Server behavior Posted by Josef Huber at 7/6/2007 2:48:00 PM Hi,
I updated our SQL Sever 200 to SP4 yesterday. Since that update we have the
problem that some FTS queries are timing out and afterwards it it not
possible to do any FTS queries and we have to reboot the server. With SP3 the
same queries caused no problems. The porblems only occur if the...more >>
Too many full-text columns or the full-text query is too complex Posted by OLAPFOREVER at 7/6/2007 7:16:03 AM Msg 9937, Level 16, State 5, Line 1
Too many full-text columns or the full-text query is too complex to be
executed.
HI
When I search for that in FTS I got this error
select * from Table1 where contains (a,b,c),'"n*"' )
but if I seach for a*, b* or z* all its ok just n* cause problem...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |