|
|
|
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 'Microsoft Search service cannot be administered under the present user error' SP3 Posted by Oz at 5/7/2004 9:38:13 PM Hi,
We have SQL Server private installation on which we are developing an
application and public installation on whict we will be deploying the
application. All instances have run Windows 2003 Enterprise Edition with SQL
2000 SP3. However, the public installation MS Search is not functioning
...more >>
Server: Msg 7607 and incremental population... Posted by Rick at 5/7/2004 11:29:08 AM Hi,
I am running a loop through a cursor, and then passing
the search string to a full-text search. This started
out working beautifully, but now I keep running into the
following error:
'Server: Msg 7607 Search on full-text
catalog 'FTCNationalCIBR' for database ID 6, table ID
2260...more >>
Counting Posted by John Doe at 5/7/2004 1:12:47 AM Consider the following:
Table setup:
ID Message-ID References
1 IDA
2 IDB IDA
3 IDC IDA IDB
4 IDD
Given the above table I am trying to select the ID, Message-ID along with
t...more >>
Yukon Full text search question... Posted by Mike Hennessy at 5/6/2004 9:13:30 AM Since I don't have access to the Beta newsgroup, I'll post here.
We are looking at evaluating the Full-Text capabilities for Yukon vs some of
the other third party vendors such as Verity, Autonomy, etc.
We have a large document base, over 20 million which are naturally
partitioned into 10 Ve...more >>
MSDE liciense Posted by How at 5/6/2004 2:53:06 AM was that MSDE is a free distribute software and have not
access limitation for the number of the user???
where i can find the more license infor for MSDE
thanks in advance ...more >>
Ranking algorithm in SQL Server 2000 Posted by Dan Crow at 5/5/2004 11:56:02 AM Hi
I'm trying to figure out exactly how the CONTAINSTABLE ranking algorithm works in SQL Server 2000. Can anyone point me to some technical documentation describing what the algorithm is? From the descriptions I've been able to find it sounds rather like TF/IDF but I'd be grateful if someone could...more >>
2 locations for noise files Posted by apowell at 5/5/2004 10:56:02 AM I found 2 locations for noise files on my server
C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQLServer\Confi
&
c:\program files\Common Files\system\mssearch\data\confi
Does one preceed the other when using a SQL query. I am guessing the SQLServer one does
...more >>
Execution of a full-text operation failed. The parameter is incorrect. Posted by lindap NO[at]SPAM empiredirect.co.uk at 5/5/2004 7:21:23 AM When I try to execute the following stored procedure:
exec sp_fulltext_database 'enable'
I get the following error:
Server: Msg 7619, Level 16, State 1, Procedure sp_fulltext_database,
Line 46
[Microsoft][ODBC SQL Server Driver][SQL Server]Execution of a
full-text operation failed. The pa...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Invalid results in FULLTEXTTABLE Search Posted by andy NO[at]SPAM workonmypc.co.uk at 5/5/2004 7:14:58 AM Help.
Have the following:
--------------------------------------------------------------------------------
SELECT
(ISNULL(CAST(RANKTBL1.RANK AS decimal),0)) +
(ISNULL(CAST(RANKTBL2.RANK AS decimal),0)/10) AS RANK,
RANKTBL1.RANK AS RANK1,
RANKTBL2.RANK AS RANK2,
items.itempkid,
...more >>
Fulltext error Posted by SK at 5/4/2004 4:15:05 PM We are running Fulltext on SQL2K sp3a with hotfix 031
cluster server running in WIN2K. Fulltext was working
fine on the primary side. When we failover test to the
secondary node, we are getting the following error in the
gather logs when we run incremental job to populate
fulltext
5/4...more >>
accent insensitive full text search Posted by Joseph Tervit at 5/4/2004 3:42:38 PM I am running SQL 2000 SP3a on Windows 2000.
Is it possible to obtain accent insensitive results from full-text searches
so that a search for café will return all records for café and cafe as if
these were the same?
In the four queries below queries 2a and 2b return the same results as each
...more >>
Question about referencing Full-Text noise file through SQL rowset functions. Posted by John Peterson at 5/4/2004 2:17:31 PM (SQL Server 2000, SP3a)
Hello all!
I'm trying to cobble together something that will let me reference the "noise.eng" (the
English list of the Full Text Search service ignored words) through Transact-SQL.
I'm trying to reference the "noise.eng" file that's located in:
C:\Program Files\C...more >>
Maximum size of the contains_search_condition clause in a CONTAINS statement Posted by Dan Crow at 5/4/2004 11:31:06 AM Hi,
We're using the SQL Server Full Text Engine to implement a search engine. Users can enter queries which are then executed using the CONTAINS statement. I can't find any documentation that indicates the maximum allowable size of the contains_search_condition clause. Our users' search terms can...more >>
Full Text Search across multiple tables (Parent-Child) Posted by martalex NO[at]SPAM hotmail.com at 5/3/2004 6:41:36 PM Is is possible to search across multiple tables (Parent-Child)?
contact(contact_id, name)
role(role_id, description)
contact_role (contact_id, role_id)
How can I find all contact where the search string is in the contact
name and or roles description?
I tried to search on contact the...more >>
Full text indexing parentheses and special characters Posted by Naresh Rajpal at 5/3/2004 1:11:09 PM select @@versio
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporatio
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4
How you tell the indexer (SQL 2K with WIN2K) to include () , /, - and all other special charac...more >>
using a "dedicated" Indexing Service Posted by MadMax at 5/3/2004 7:31:18 AM Hi all,
I'm doing some experiments with Indexing Service and MS-SQLServer 2000.
With the help of the documentation, I easily managed to configure the local Indexing Service as
a linkedserver and now I can run full text query from SQL accessing both the SQL tables
and the Indexing Service cat...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |