Enabling Full Text

Is it possible to enable full text indexing on SQL Server without
re-installing (assuming that the full text option was not selected when SQL
was first installed)?
Dirk,
Yes. However, it depends upon the SQL Server version (7.0, 2000 or now 2005)
that you are using... Could you post the full output of -- SELECT
@.@.version -- as this is very helpful info in troubleshooting SQL FTS issues.
FYI, SQL Server 2000 installs the Full-text Search (FTS) components by
default, while SQL Server 7.0 doesn't, but you can use your SQL 7.0 CD and
use "custom installation" and under the server components, select "Full-text
Search".
Regards,
John
"Dirk" <Dirk@.discussions.microsoft.com> wrote in message
news:8A7F6B05-3486-44E1-8763-C1F471B053FA@.microsoft.com...
> Is it possible to enable full text indexing on SQL Server without
> re-installing (assuming that the full text option was not selected when
SQL
> was first installed)?
|||Here it is:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
NT 5.0 (Build 2195: Service Pack 4)
"John Kane" wrote:

> Dirk,
> Yes. However, it depends upon the SQL Server version (7.0, 2000 or now 2005)
> that you are using... Could you post the full output of -- SELECT
> @.@.version -- as this is very helpful info in troubleshooting SQL FTS issues.
> FYI, SQL Server 2000 installs the Full-text Search (FTS) components by
> default, while SQL Server 7.0 doesn't, but you can use your SQL 7.0 CD and
> use "custom installation" and under the server components, select "Full-text
> Search".
> Regards,
> John
>
> "Dirk" <Dirk@.discussions.microsoft.com> wrote in message
> news:8A7F6B05-3486-44E1-8763-C1F471B053FA@.microsoft.com...
> SQL
>
>
|||Dirk,
I stand corrected... "SQL Server 2000 installs the Full-text Search (FTS)
components by default," should of been "SQL Server 2000 installs the
Full-text Search (FTS) components by default for Standard Edition and
above". Since, you're using Developer Edition (and THAT is why I asked for
the @.@.version info!), this edition does NOT install the FTS components by
default and you can use the same procedures as I described for SQL Server
7.0...
Basically, you can use your SQL 2000 Developer Edition CD and run setup and
select "custom installation" and under the server components select
"Full-text Search" and the CD will install these components for you. Note,
if you have applied any Service Pack (SPx) to your Developer Edition, you
will need to re-install the SP as well so that any FTS &/or MSSearch fixes
can be applied.
Regards,
John
"Dirk" <Dirk@.discussions.microsoft.com> wrote in message
news:C0C7237E-BDAA-47CD-95E7-47A5476C0841@.microsoft.com...
> Here it is:
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on
Windows[vbcol=seagreen]
> NT 5.0 (Build 2195: Service Pack 4)
>
> "John Kane" wrote:
2005)[vbcol=seagreen]
issues.[vbcol=seagreen]
and[vbcol=seagreen]
"Full-text[vbcol=seagreen]
when[vbcol=seagreen]

Empty result set

I am trying to produce a report with the page headers always showing. If the
result set is empty I need to add a "No entries found for the selected
criteria" line below the headers. If I use the NoRows property it does not
include the headers in the report, which is a requirement. Is there a way to
do this?What I do is add a table footer, and in that footer put an expression that
says iif(count(Fields!yourdata.value)=0,"No entries found","").
"MikeS" wrote:
> I am trying to produce a report with the page headers always showing. If the
> result set is empty I need to add a "No entries found for the selected
> criteria" line below the headers. If I use the NoRows property it does not
> include the headers in the report, which is a requirement. Is there a way to
> do this?|||I've tried to do this with the footer, but I get a message indicating
otherwise:
The value expression for the textbox â'textbox5â' refers to a field. Fields
cannot be used in page headers or footers.
I'd love to avoid sending a blank report, but if a 'no data is found'
message will work, that would be good. can you guys help?
-- Lynn
"dachrist" wrote:
> What I do is add a table footer, and in that footer put an expression that
> says iif(count(Fields!yourdata.value)=0,"No entries found","").
> "MikeS" wrote:
> > I am trying to produce a report with the page headers always showing. If the
> > result set is empty I need to add a "No entries found for the selected
> > criteria" line below the headers. If I use the NoRows property it does not
> > include the headers in the report, which is a requirement. Is there a way to
> > do this?