SQL Express Advanced

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LongbowShawn - 18 Jun 2008 23:09 GMT

I have an instance of SQL Express 2005 with the Advanced Tools
installed on an XP machine. I can turn on full text in the DB
property window but there are no other nodes in the management studio
for full-text. There's no storage node or other menu/properties for
full-text. The fulltext service for this instance is running but I
don't see mssearch anywhere. Isn't that required? There is an Index
service loaded but no mssearch. What do you think I'm missing.

Thanks!

Reply to this Message

Hilary Cotter - 19 Jun 2008 13:07 GMT

SQL 2005 no longer uses mssearch, but rather MSFTESQL and MSFTED.

The folders might not show up for Express, but can you full-text query your
tables?

>I have an instance of SQL Express 2005 with the Advanced Tools
> installed on an XP machine. I can turn on full text in the DB
[quoted text clipped - 5 lines]
>
> Thanks!

Reply to this Message

LongbowShawn - 20 Jun 2008 15:19 GMT

> SQL 2005 no longer uses mssearch, but rather MSFTESQL and MSFTED.
>
[quoted text clipped - 12 lines]
>
> - Show quoted text -

First I have to set up the catalogues and tables. So you're saying it
works but I have to use scripting instead of the studio to set up the
cats and tables?

Reply to this Message

LongbowShawn - 24 Jun 2008 14:54 GMT

> SQL 2005 no longer uses mssearch, but rather MSFTESQL and MSFTED.
>
[quoted text clipped - 12 lines]
>
> - Show quoted text -

So is that correct? With SQL Express advanced you cannot use the
studio to manage the full-text info, I have to use scripts?

Reply to this Message

Russell Fields - 24 Jun 2008 16:19 GMT

Correct. You have to use scripts.

There are a number of SQL Server 2005 Express learning videos at the
following site. Video 13 is about full-text indexing.
http://www.microsoft.com/sql/editions/express/learnvideos.mspx

RLF

On Jun 19, 7:07 am, "Hilary Cotter" <hilary.cot...@gmail.com> wrote:

> SQL 2005 no longer uses mssearch, but rather MSFTESQL and MSFTED.
>
[quoted text clipped - 17 lines]
>
> - Show quoted text -

So is that correct? With SQL Express advanced you cannot use the
studio to manage the full-text info, I have to use scripts?

Reply to this Message

LongbowShawn - 24 Jun 2008 19:57 GMT

On Jun 24, 10:19 am, "Russell Fields" <russellfie...@nomail.com>
wrote:

> Correct. You have to use scripts.
>
[quoted text clipped - 31 lines]
>
> - Show quoted text -

Thanks!

Reply to this Message