| Groups | Blog | Home |
|
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 |
Filter by week: 1 2 3 4 5 Unexpected NULL value returned for the column Posted by Jason Davis at 7/31/2003 11:40:46 PM Hilary, John, SOS!
I had a major crisis with my sql server today.
After applying Hilary's great advice from here: http://tinyurl.com/inyn I
was able to get things in order.
I'm getting this new error now. It disappers after I try to re-build, but as
soon as I populate (full/incremenet) - I ...more >>
More of the same...(sorry about the cross-post) Posted by David Sanders at 7/31/2003 1:29:27 PM Is there any way, shape or form that the following stored procdure can be
called successfully? Basically I am trying to passing in a WHERE clause
that contains some full-text predicates (CONTAINS, etc...). This WHERE
clause has to be a variable passed in. The 'public' role has NO rights to
th...more >>
Forum searching: cumulative results from many posts, one topic Posted by jeffyjones NO[at]SPAM hotmail.com at 7/31/2003 12:53:02 PM I'm trying to write a search query for a forum. I've started with
this:
SELECT Posts.TopicID, ft.[RANK]
FROM Posts INNER JOIN FREETEXTTABLE (Posts, *, @SeachTerm, 100) AS ft
ON Posts.PostID = ft.[KEY]
ORDER BY ft.[RANK] DESC
No problem there, and it's fast and the results are really accura...more >>
Problem with Full Text Population Posted by jvoss NO[at]SPAM discover-re.com at 7/31/2003 7:07:15 AM Hello,
One of our people started to make a full text index on a table. The
table has over 8 million records and would take about 3 days to
complete. Our boss wants to stop the population process of the index
but it does not appear to be stopping. They have issued the command
from the SQL...more >>
FTS and noise words Posted by (idror NO[at]SPAM healthology.com) at 7/30/2003 9:00:24 AM Why when searching for more than one word in a text search and at least one word (but not all) is a noise word i get the msg - "The query contained only ignored words" .
for example : if the search text is "what does Allergist do?" i get the msg despite the fact "Allergist" is not noise word.
this...more >>
FTS with SQL 2000 doesn't run on Windows 2000. True? Posted by Pete at 7/29/2003 4:28:19 PM I ran into this white paper on FTS with SQL 2000,
http://support.microsoft.com/default.aspx?scid=kb;en-
us;323739
in which it states that if you install the SQL 2000 on
Windows 2000, the FTS service is not available. I also
read some threads talking about the availablity problem of
FTS ...more >>
Strange problem Starting/Stopping FTS Posted by Greg D. Moore (Strider) at 7/29/2003 1:22:31 AM
Ok, yet another strange FTS problem.
We're still running SQL 7.0 SP2 (can't upgrade yet) under Windows 2000.
We've had more than our share of FTS issues.
So the latest is, on our primary, I build a brand new catalog of our main
table. No problems.
4-5 days later, it finishes.
So the...more >>
Full text and noise word file Posted by atelford6 NO[at]SPAM hotmail.com at 7/29/2003 12:34:41 AM I have an active passive cluster in a production environment. I also
have a non-clustered sql server for testing. I made a change to the
noise.enu file to remove some noise words, I did this on test and
everything worked fine. I then went to production and did the exact
same thing, stopped full-...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
| home · blog · groups | Questions? Comments? Contact the dn |