| 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 |
Indexing PDFs in SQL Server 2005 Posted by ddaiker at 12/29/2006 8:49:57 AM I'm having troubles getting SQL Server 2005 FTS to index PDFs stored in
and image field with a doctype field value of "PDF". The file is being
processed as I can query on the filename but I get no hits when
querying any of the content. FiltDump returns all the plain text of
the document.
I'...more >>
How do I identify the pdf file that the fulltext index is stalled Posted by telaan at 12/21/2006 6:03:00 PM Hello,
We just installed the Adobe iFilter and have rebuilt the fulltext catalog to
pickup the old filters. The catalog is able to add new items and picked up
most of the old ones, but it is stuck on 'Population in progress'. I found a
post that indicates that one or more files (specificall...more >>
search phrase as google does Posted by tolgay at 12/21/2006 12:00:00 AM Hi
I have been trying to find a query method in sql. Google engines search
phrases and find the best suitable result .
for instance if you write (play station) it can find all suitable result in
"playstation" or "play station" but I could not do it in sql(2000) even in
fulltext search
I tri...more >>
Document properties Posted by Larry Brown at 12/18/2006 4:16:17 PM Hi,
In Office documents for example, you have document properties like
Doc_Author, or other properties that may have been created by the user who
wrote the doc.
In SQL Server 2005, it is possible to search into these properties
(equivalent of Index Server ALL property). But is there any ...more >>
File properties for files stored in IMAGE field Posted by ddaiker NO[at]SPAM gmail.com at 12/18/2006 11:12:31 AM Is there a way (in SQL Server 2005 full-text search) to search the
properties (DocType, Keyword, etc) of files stored and indexed in image
fields? I'm searching the indexed contents with no problem but I also
want to search the properties. I know that this isn't possible in
versions prior to 2...more >>
BUG: freetexttable query never completes nor times out? Posted by geek-y-guy at 12/15/2006 10:52:33 AM Hi All:
server2003 R2 standard, sp1
Microsoft SQL Server Management Studio 9.00.2047.00
Microsoft Analysis Services Client Tools 2005.090.2047.00
Microsoft Data Access Components (MDAC) 2000.086.1830.00
(srv03_sp1_rtm.050324-1447)
Microsoft MSXML 2.6 3.0 6.0
Microsoft...more >>
full text not populate in secundary cluster node Posted by Ana R. Pulido at 12/15/2006 12:00:00 AM
Hello
We have 2 boxes running clustered windows 2000, SQL server 2000 sp4 in
clustered mode, we have 2 instance of sql server in each node, and full text
indexing run ok in the primary node but it fails in the instance of the
secundary node, when I looked at the FTSDATA logs (with gthrlog....more >>
Full text not populating on failover node, SQL 2000 SP3 clustering Posted by tabarnak NO[at]SPAM gmail.com at 12/14/2006 8:00:52 AM Hello
We have 2 boxes running clustered windows 2000, SQL server 2000
sp3 in clustered mode, and full text indexing will not index. The
properties
of the number of item indexed is 1.
When I looked at the FTSDATA logs I had these:
12/10/2006 3:00:04 AM Add Started Incremental crawl
12/1...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
FTI, Searching and other Filters Posted by Kyle Jedrusiak at 12/13/2006 2:09:42 PM We have this table...
CREATE TABLE [dbo].[Document](
[DocumentID] [int] IDENTITY(1,1) NOT NULL,
[HumanResourceID] [int] NOT NULL,
[Name] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [nvarchar](256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT
NULL...more >>
SQL Server 2005 Fulltext .MSG Problem Posted by plaetzchen at 12/13/2006 12:09:02 AM Hello!
I have a big Problem using external filters with SQL server 05 (W2k3
server).
To index .msg and .pdf files i have installed ifilters from mircosoft
(msg) and adobe ifilter 6 (pdf)
and changed sql server to user os-filters (sp_fulltext_service
'load_os_resources', 1) and to use
filter...more >>
Newbie question, fulltext and SQL Server Express with Advanced Services Posted by Larry Brown at 12/13/2006 12:00:00 AM Hello,
Sorry, my question is quite long...
I'm testing fulltext search on a SQL Server Express 2005 with Advanced
Services. I've never tested fulltext search on any SQL Server before...
My problem is simple: I can't get anything to work... :)
Here is what I have:
A) Database: named ...more >>
SQL Server Express with Advanced Services: performances and capacity Posted by Larry Brown at 12/13/2006 12:00:00 AM Hi again,
I'm testing fulltext in SQL Server Express with Advanced Services, and it
seems to work very well now.
My question is: is there any limitation in terms of capacity or performance
to this version of SQL Server, in comparison to SQL Server itself ? And if
yes, which is(are) the l...more >>
SQL as a web search engine Posted by Oren Levy at 12/12/2006 5:51:00 PM Hi All
I’m trying to write a SQL statement for a web search engine, it should do
the following:
Break down the search string into individual words (for example: “500 MHz
microprocessor USBâ€) and do a Full Text Search on a catalogue for each
individual word and sort it by the rank.
I...more >>
Ranked Searching and Organization of Data for efficiency using FTS Posted by datherton NO[at]SPAM xunity.com at 12/11/2006 7:01:52 PM Hello All,
Looking to get to some insight into how I should go about setting up a
Full Text Search with, to put it lightly, a huge set of normalized
data. We would be collecting various sets of resume based fielded data
along the lines skills, education, etc... and the resume itself. The
sets o...more >>
fulltext logical files offline and can't be deleted Posted by peter.daniels NO[at]SPAM ihs.com at 12/7/2006 3:04:29 PM Microsoft SQL Server 2005 - 9.00.2047.00 (X64) Apr 14 2006 01:11:53
Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition
(64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
I have a database with one data file, one log file and 2 bogus, offline
FT "files":
FileGroupName F...more >>
Union with duplicated records Posted by Oren Levy at 12/6/2006 5:51:01 PM Hi Everyone.
I have a problem that I could not figure out what to do with it.
I have a couple of tables and views. All have the same unique ID.
When a user try to do a search on our web site we want to try to look in
multiple tables and views, Rank the results and aggregate the results back...more >>
install Office ifilter on SQL Server 2005 Posted by Jeremy Holland at 12/6/2006 2:47:12 AM Hi there
I might be being dense, but I can't seem to get the Full Text Search
service working for office type documents. The service works OK for
text and RTF files, so I know that the Full Text indexing service is
there, but just doesn't seem to be working for Office docs -
specifially Word ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |