Re: SQL Server 2005 Express Edition Advanced

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Paul,

Have you seen this training video:
http://download.microsoft.com/download/b/3/8/b3847275-2bea-440a-8e2e-305b009bb261/sql_13.wmv

This covers downloading, installing, etc. About 7 minutes in, it describes
how to enable/disable full-text indexing for a database. It is a check box
on the Database Properties / Files page.

After that, it appears that the creating of indexes is done through TSQL,
not through the studio.

RLF
"Paul Johnson" <pjohnson@xxxxxxxxxxxxxxxxx> wrote in message
news:uNJJ9CljHHA.5048@xxxxxxxxxxxxxxxxxxxxxxx
Thank you for your reply.

I looked at the chart and the Express edition with Advance services has
Full Text searching. This is what I have installed but dont seem to be
able to reference it in the management studio.

Regards,
Paul.


"Russell Fields" <russellfields@xxxxxxxxxx> wrote in message
news:%23ldTj%23kjHHA.2368@xxxxxxxxxxxxxxxxxxxxxxx
Paul,

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
"Available for SQL Server Express in the SQL Server Express w/ Advanced
Services download"

RLF

"Paul Johnson" <pjohnson@xxxxxxxxxxxxxxxxx> wrote in message
news:%236Nw9lkjHHA.3980@xxxxxxxxxxxxxxxxxxxxxxx
Good Day,

I have installed SQl server 2005 edition Advance but can not see any
tree items in the management studio for Full Text searching. If I right
click on a database table I do not have an option to create an index.
Also if I right click on a database and select properties then file, the
enable full text indexing checkbox is disabled.

The service is running. Can anyone help.

Regards,
Paul.








.

Relevant Pages

  • Re: Administering MSDE
    ... Thanks for posting in our newsgroup and also for Costas's input. ... SQL Server Web Data Administrator ... Installing Microsoft Windows Server Update Services 3.0 on Windows Small ... Installing WSUS 3.0 won't affect the SharePoint database. ...
    (microsoft.public.windows.server.sbs)
  • Re: RESTORING CRASHED SITE WEBS
    ... Well, when installing Sharepoint, the installer did display a message ... I can't login using any existing accounts. ... >> access using Windows Security the account returned in the failed ... I put in the database server name and ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: stable vs. sargein apt-get: are they interchangeable?
    ... This updated the entire database. ... > downloading and installing two applications. ...
    (Debian-User)
  • Re: RESTORING CRASHED SITE WEBS
    ... they are already there) before installing WSS and then to add them back ... >>> I have everything kind of restored but can't access the SQL ... I can't login using any existing accounts. ... I put in the database server name and ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Bug in Jet engine ?
    ... I would agree with Bill. ... >> installing anything it didn't, ... >> clean database), reinstalling latest MDAC and JET engine. ...
    (microsoft.public.data.ado)