2012年3月9日星期五

Full text index

I am trying to setup full text search on a table.
The database has use full text indexing checked in properties.files
When I right click the table the full text selection is not there.
In other installs this table works and is setup for full text it has a key
on a single field.
What am I missing
Thank you
--
JerryHi Jerry,
I understand that you could not see the full-text index for your table when
you right clicked your table.
If I have misunderstood, please let me know.
To let me better understand your scenario, could you please let me know:
1. What is the version of your SQL Server?
2. How did you create a Full-Text index on your table?
Generally if a full-text index was correctly created,
for SQL Server 2005, you can see a table full-text index via right clicking
the table, selecting Full-Text index, and selecting Properties,
and for SQL Server 2000, you can see a table full-text index via right
clicking the table, selecting Properties, and selecting the tab "Full-Text
Searching".
You may check if you enable the table for Full-Text indexing:
How to: Enable a Table for Full-Text Indexing (SQL Server Management Studio)
http://technet.microsoft.com/en-us/library/ms142536.aspx
Full-text Querying SQL Server Data
http://msdn2.microsoft.com/en-us/library/aa172886(SQL.80).aspx
Generally to create a full-text indexing on a table, you should do the
following steps:
1. Create a full-text catalog for storing full-text indexes;
2. Define a population schedule;
3. Create a full-text index in the full-text catalog
Of course, you can use "Define Full-Text Index..." wizard (right click the
table and select Full-Text Index) in SQL 2005 Management Studio or "Define
Full-Text Indexing on a Table" wizard (right click the table and select
Full-Text Index Table) in SQL 2000 Enterprise Manager.
You may also want the following references:
Full-Text Search How-to Topics
http://technet.microsoft.com/en-us/library/ms142503.aspx
CREATE FULLTEXT INDEX (Transact-SQL)
http://technet.microsoft.com/en-us/library/ms187317.aspx
Enabling Others to Issue Full-Text Queries
http://technet.microsoft.com/en-us/library/aa214776(SQL.80).aspx
Hope this helps. If you have any other questions or concerns, please feel
free to let me know. Have a good day!
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Charles,
Thank you for your reply.
I am using sql server 2005.
The data base has full text enabled. Properties , Files, check full text.
and apply
The next step is to right click the table and select full text from the
menu. The full text selection is not on the menu.
Where do I go from here.
Thank you
--
Jerry
"Charles Wang[MSFT]" wrote:
> Hi Jerry,
> I understand that you could not see the full-text index for your table when
> you right clicked your table.
> If I have misunderstood, please let me know.
> To let me better understand your scenario, could you please let me know:
> 1. What is the version of your SQL Server?
> 2. How did you create a Full-Text index on your table?
> Generally if a full-text index was correctly created,
> for SQL Server 2005, you can see a table full-text index via right clicking
> the table, selecting Full-Text index, and selecting Properties,
> and for SQL Server 2000, you can see a table full-text index via right
> clicking the table, selecting Properties, and selecting the tab "Full-Text
> Searching".
> You may check if you enable the table for Full-Text indexing:
> How to: Enable a Table for Full-Text Indexing (SQL Server Management Studio)
> http://technet.microsoft.com/en-us/library/ms142536.aspx
> Full-text Querying SQL Server Data
> http://msdn2.microsoft.com/en-us/library/aa172886(SQL.80).aspx
> Generally to create a full-text indexing on a table, you should do the
> following steps:
> 1. Create a full-text catalog for storing full-text indexes;
> 2. Define a population schedule;
> 3. Create a full-text index in the full-text catalog
> Of course, you can use "Define Full-Text Index..." wizard (right click the
> table and select Full-Text Index) in SQL 2005 Management Studio or "Define
> Full-Text Indexing on a Table" wizard (right click the table and select
> Full-Text Index Table) in SQL 2000 Enterprise Manager.
> You may also want the following references:
> Full-Text Search How-to Topics
> http://technet.microsoft.com/en-us/library/ms142503.aspx
> CREATE FULLTEXT INDEX (Transact-SQL)
> http://technet.microsoft.com/en-us/library/ms187317.aspx
> Enabling Others to Issue Full-Text Queries
> http://technet.microsoft.com/en-us/library/aa214776(SQL.80).aspx
> Hope this helps. If you have any other questions or concerns, please feel
> free to let me know. Have a good day!
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> =====================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>|||Hi Jerry,
For further research, I would like to know:
What is the edition of your SQL Server 2005 , Express Edition or Standard
Edition or Enterprise Edition?
My test is based on SQL Server 2005 Enterprise Edition SP2.
You may first check your Services panel to ensure that SQL Server FullText
Search is there and started.
If FullText Search Services is started and this issue persists, I recommend
that you try uninstalling/reinstalling your Client Tools from Add/Remove
Programs:
Select your SQL Server 2005, click the Remove button, select the
Workstation Components and click Finish button.
After that, install the Client Tools from the Tools setup folder in your
SQL Server 2005 setup CD.
Hope this helps. If you have any questions or concerns, please feel free to
post back.
Best regards,
Charles Wang
Microsoft Online Community Support
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Charles,
Thank you for the reply.
The SQL server is the standard edition.
We uninstalled and reinstalled the workstation components and still have the
same problem.
in the step for setting up the full text:
Right click the table and select full text the full text selection in not in
the list.
The table has a single field set as a key and it is a identity column. This
works on other installs of SQL server. What could be the problem.
Thank you
Jerry
"Charles Wang[MSFT]" wrote:
> Hi Jerry,
> For further research, I would like to know:
> What is the edition of your SQL Server 2005 , Express Edition or Standard
> Edition or Enterprise Edition?
> My test is based on SQL Server 2005 Enterprise Edition SP2.
> You may first check your Services panel to ensure that SQL Server FullText
> Search is there and started.
> If FullText Search Services is started and this issue persists, I recommend
> that you try uninstalling/reinstalling your Client Tools from Add/Remove
> Programs:
> Select your SQL Server 2005, click the Remove button, select the
> Workstation Components and click Finish button.
> After that, install the Client Tools from the Tools setup folder in your
> SQL Server 2005 setup CD.
> Hope this helps. If you have any questions or concerns, please feel free to
> post back.
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ======================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>|||Hi Jerry,
To let me better understand your issue, could you please mail me
(changliw_at_microsoft_dot_com) some screenshots of this issue?
If you meant that you could see "Full-Text Index" when you right clicked
the table, but that you could not define a full-text index for the table
during the "Define Full-text Index" wizard, this should be an expected
result since your table had just one column which was an identity Key
column. Only a column which type is char, nchar, varchar, nvarchar,text,
ntext, image, xml, or varbinary can be indexed for full-text search.
You may refer to:
CREATE FULLTEXT INDEX (Transact-SQL)
http://technet.microsoft.com/en-us/library/ms187317.aspx
If I have any misunderstanding, please feel free to point out. I appreciate
your mailing me the screenshots so that I can accurately understand your
issue.
Best regards,
Charles Wang
Microsoft Online Community Support
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Charles
Thank you for your reply.
I cannot see "Full-Text Index" when I right clicked the table.
There is no selection "Full-Text Index" in the popup menu when I right click
the table
Thank you
Jerry
"Charles Wang[MSFT]" wrote:
> Hi Jerry,
> To let me better understand your issue, could you please mail me
> (changliw_at_microsoft_dot_com) some screenshots of this issue?
> If you meant that you could see "Full-Text Index" when you right clicked
> the table, but that you could not define a full-text index for the table
> during the "Define Full-text Index" wizard, this should be an expected
> result since your table had just one column which was an identity Key
> column. Only a column which type is char, nchar, varchar, nvarchar,text,
> ntext, image, xml, or varbinary can be indexed for full-text search.
> You may refer to:
> CREATE FULLTEXT INDEX (Transact-SQL)
> http://technet.microsoft.com/en-us/library/ms187317.aspx
> If I have any misunderstanding, please feel free to point out. I appreciate
> your mailing me the screenshots so that I can accurately understand your
> issue.
>
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ======================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>
>|||I missed beginning of this thread, so apologies of I'm off base:
Did you install full-text indexing for the instance? If not, you can add it after.
Did you create a full-text catalog for the database?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jerry C" <jerryed@.nospam.nospam> wrote in message
news:3329E859-E11A-4F39-B037-8CFCE0A03994@.microsoft.com...
> Charles
> Thank you for your reply.
> I cannot see "Full-Text Index" when I right clicked the table.
> There is no selection "Full-Text Index" in the popup menu when I right click
> the table
> Thank you
>
> --
> Jerry
>
> "Charles Wang[MSFT]" wrote:
>> Hi Jerry,
>> To let me better understand your issue, could you please mail me
>> (changliw_at_microsoft_dot_com) some screenshots of this issue?
>> If you meant that you could see "Full-Text Index" when you right clicked
>> the table, but that you could not define a full-text index for the table
>> during the "Define Full-text Index" wizard, this should be an expected
>> result since your table had just one column which was an identity Key
>> column. Only a column which type is char, nchar, varchar, nvarchar,text,
>> ntext, image, xml, or varbinary can be indexed for full-text search.
>> You may refer to:
>> CREATE FULLTEXT INDEX (Transact-SQL)
>> http://technet.microsoft.com/en-us/library/ms187317.aspx
>> If I have any misunderstanding, please feel free to point out. I appreciate
>> your mailing me the screenshots so that I can accurately understand your
>> issue.
>>
>> Best regards,
>> Charles Wang
>> Microsoft Online Community Support
>> ======================================================>> When responding to posts, please "Reply to Group" via
>> your newsreader so that others may learn and benefit
>> from this issue.
>> ======================================================>> This posting is provided "AS IS" with no warranties, and confers no rights.
>> ======================================================>>
>>|||Tibor,
Thank you for the reply.
I checked here for how to create a full-text catalog:
http://technet.microsoft.com/en-us/library/bb326035.aspx
in step 2:
Expand Storage, and then right-click Full Text Catalogs.
There is no Storage selection.
What could be wrong.
Thank you
--
Jerry
"Tibor Karaszi" wrote:
> I missed beginning of this thread, so apologies of I'm off base:
> Did you install full-text indexing for the instance? If not, you can add it after.
> Did you create a full-text catalog for the database?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Jerry C" <jerryed@.nospam.nospam> wrote in message
> news:3329E859-E11A-4F39-B037-8CFCE0A03994@.microsoft.com...
> > Charles
> >
> > Thank you for your reply.
> >
> > I cannot see "Full-Text Index" when I right clicked the table.
> >
> > There is no selection "Full-Text Index" in the popup menu when I right click
> > the table
> >
> > Thank you
> >
> >
> >
> > --
> > Jerry
> >
> >
> > "Charles Wang[MSFT]" wrote:
> >
> >> Hi Jerry,
> >> To let me better understand your issue, could you please mail me
> >> (changliw_at_microsoft_dot_com) some screenshots of this issue?
> >>
> >> If you meant that you could see "Full-Text Index" when you right clicked
> >> the table, but that you could not define a full-text index for the table
> >> during the "Define Full-text Index" wizard, this should be an expected
> >> result since your table had just one column which was an identity Key
> >> column. Only a column which type is char, nchar, varchar, nvarchar,text,
> >> ntext, image, xml, or varbinary can be indexed for full-text search.
> >> You may refer to:
> >> CREATE FULLTEXT INDEX (Transact-SQL)
> >> http://technet.microsoft.com/en-us/library/ms187317.aspx
> >>
> >> If I have any misunderstanding, please feel free to point out. I appreciate
> >> your mailing me the screenshots so that I can accurately understand your
> >> issue.
> >>
> >>
> >> Best regards,
> >> Charles Wang
> >> Microsoft Online Community Support
> >>
> >> ======================================================> >> When responding to posts, please "Reply to Group" via
> >> your newsreader so that others may learn and benefit
> >> from this issue.
> >> ======================================================> >> This posting is provided "AS IS" with no warranties, and confers no rights.
> >> ======================================================> >>
> >>
> >>
> >>
> >>
>|||What version of the database engine are you using? What client tool are you using? What version of
the client tool? Are you expanding your database in Management Studio, but don't find a storage
section?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jerry C" <jerryed@.nospam.nospam> wrote in message
news:507FD33A-0F52-4255-BB97-BD0DD043C623@.microsoft.com...
> Tibor,
> Thank you for the reply.
> I checked here for how to create a full-text catalog:
> http://technet.microsoft.com/en-us/library/bb326035.aspx
> in step 2:
> Expand Storage, and then right-click Full Text Catalogs.
> There is no Storage selection.
> What could be wrong.
> Thank you
> --
> Jerry
>
> "Tibor Karaszi" wrote:
>> I missed beginning of this thread, so apologies of I'm off base:
>> Did you install full-text indexing for the instance? If not, you can add it after.
>> Did you create a full-text catalog for the database?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> "Jerry C" <jerryed@.nospam.nospam> wrote in message
>> news:3329E859-E11A-4F39-B037-8CFCE0A03994@.microsoft.com...
>> > Charles
>> >
>> > Thank you for your reply.
>> >
>> > I cannot see "Full-Text Index" when I right clicked the table.
>> >
>> > There is no selection "Full-Text Index" in the popup menu when I right click
>> > the table
>> >
>> > Thank you
>> >
>> >
>> >
>> > --
>> > Jerry
>> >
>> >
>> > "Charles Wang[MSFT]" wrote:
>> >
>> >> Hi Jerry,
>> >> To let me better understand your issue, could you please mail me
>> >> (changliw_at_microsoft_dot_com) some screenshots of this issue?
>> >>
>> >> If you meant that you could see "Full-Text Index" when you right clicked
>> >> the table, but that you could not define a full-text index for the table
>> >> during the "Define Full-text Index" wizard, this should be an expected
>> >> result since your table had just one column which was an identity Key
>> >> column. Only a column which type is char, nchar, varchar, nvarchar,text,
>> >> ntext, image, xml, or varbinary can be indexed for full-text search.
>> >> You may refer to:
>> >> CREATE FULLTEXT INDEX (Transact-SQL)
>> >> http://technet.microsoft.com/en-us/library/ms187317.aspx
>> >>
>> >> If I have any misunderstanding, please feel free to point out. I appreciate
>> >> your mailing me the screenshots so that I can accurately understand your
>> >> issue.
>> >>
>> >>
>> >> Best regards,
>> >> Charles Wang
>> >> Microsoft Online Community Support
>> >>
>> >> ======================================================>> >> When responding to posts, please "Reply to Group" via
>> >> your newsreader so that others may learn and benefit
>> >> from this issue.
>> >> ======================================================>> >> This posting is provided "AS IS" with no warranties, and confers no rights.
>> >> ======================================================>> >>
>> >>
>> >>
>> >>
>> >>|||Hi Jerry,
For further research, I would like to check with you whether you can
manually create the Full-text index on a table.
I recommend that you try the following:
1. Ensure Microsoft Full-Text Engine has been installed. You can check this
from your computer Services list. The service name is SQL Server FullText
Search (MSSQLSERVER).
2. Enable your database to using Full-text indexing via SSMS or running
sp_fulltext_database 'enable'.
3. Manually run CREATE FULLTEXT CATALOG to create a catalog for storing
full-text indexes. For more information and samples, please refer to CREATE
FULLTEXT CATALOG (Transact-SQL) in SQL Server 2005 Books Online.
4. Manually run CREATE FULLTEXT INDEX to create a full-text index on a
table. For more information and samples, please refer to CREATE FULLTEXT
INDEX in SQL Server 2005 Books Online.
If you can manually create the full-text index, but you still could not see
the full-text selection when you right click the table. I would like to
check with you the following information:
1. Has the latest service pack (SP2) of SQL Server 2005 been installed to
the instance of your SQL Server 2005 Standard Edition? (Run SELECT
@.@.VERSION)
If not, please try installing the SP2 to see if it helps. You can
download it from:
Microsoft SQL Server 2005 Service Pack 2
https://www.microsoft.com/downloads/details.aspx?familyid=D07219B2-1E23-49C8
-8F0C-63FA18F26D3A&displaylang=en
2. Did this issue occur on your other machine with the SQL Server 2005
Edition?
If installing SP2 could not solve the problem, please check if you can
reproduce this issue on other machine. If this issue could not be
reproduced, you may consider uninstalling/reinstalling Full-Text index
component under Database Engine to see if it helps.
From Control Panel, click Add or Remove Programs, select SQL Server
2005, click Change, select SQL Server 2005 Instances-> "MSSQLSERVER:
Database Engine,...", click Next, select Database Engine, click Next,
follow the wizard to the Database Engine components page, select the
Full-Text index to uninstall, and click Next.
After that, reinstall the component from your SQL Server 2005 setup CD.
If this still cannot resolve the issue, I am afraid that you may consider
reinstalling your SQL Server thoroughly.
If you have any questions or concerns, please feel free to let me know.
Have a good day!
Best regards,
Charles Wang
Microsoft Online Community Support
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Charles,
Thank you for the reply,
I have checked everything in the list.
Step 1 Full text is in the services list and started.
Step 2 I have run sp_fulltext_database 'enable' and it returned a success
message.
also the full text check box is checked in the database files page.
Step 3 CREATE FULLTEXT CATALOG returns a success message but I connot find a
catalog anywhere with the SQL server management studio
Step 4 CREATE FULLTEXT INDEX ran ok using this line
CREATE FULLTEXT INDEX ON Metadata KEY INDEX PK_Metadata
and it returned
A full-text index for table or indexed view 'Metadata' has already been
created.
(SP2) of SQL Server 2005 is installed the select @.@.Version
Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation Express Edition with Advanced
Services on Windows NT 5.2 (Build 3790: Service Pack 2)
I will do the reinstall today and see if it helps.
Tibor, Thank you for your reply, this is the about information for this
install.
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.086.3959.00
(srv03_sp2_rtm.070216-1710)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.832
Operating System 5.2.3790
I am using sql server management studio. I expand the database and there is
no storage section.
Thank you
--
Jerry
"Charles Wang[MSFT]" wrote:
> Hi Jerry,
> For further research, I would like to check with you whether you can
> manually create the Full-text index on a table.
> I recommend that you try the following:
> 1. Ensure Microsoft Full-Text Engine has been installed. You can check this
> from your computer Services list. The service name is SQL Server FullText
> Search (MSSQLSERVER).
> 2. Enable your database to using Full-text indexing via SSMS or running
> sp_fulltext_database 'enable'.
> 3. Manually run CREATE FULLTEXT CATALOG to create a catalog for storing
> full-text indexes. For more information and samples, please refer to CREATE
> FULLTEXT CATALOG (Transact-SQL) in SQL Server 2005 Books Online.
> 4. Manually run CREATE FULLTEXT INDEX to create a full-text index on a
> table. For more information and samples, please refer to CREATE FULLTEXT
> INDEX in SQL Server 2005 Books Online.
> If you can manually create the full-text index, but you still could not see
> the full-text selection when you right click the table. I would like to
> check with you the following information:
> 1. Has the latest service pack (SP2) of SQL Server 2005 been installed to
> the instance of your SQL Server 2005 Standard Edition? (Run SELECT
> @.@.VERSION)
> If not, please try installing the SP2 to see if it helps. You can
> download it from:
> Microsoft SQL Server 2005 Service Pack 2
> https://www.microsoft.com/downloads/details.aspx?familyid=D07219B2-1E23-49C8
> -8F0C-63FA18F26D3A&displaylang=en
> 2. Did this issue occur on your other machine with the SQL Server 2005
> Edition?
> If installing SP2 could not solve the problem, please check if you can
> reproduce this issue on other machine. If this issue could not be
> reproduced, you may consider uninstalling/reinstalling Full-Text index
> component under Database Engine to see if it helps.
> From Control Panel, click Add or Remove Programs, select SQL Server
> 2005, click Change, select SQL Server 2005 Instances-> "MSSQLSERVER:
> Database Engine,...", click Next, select Database Engine, click Next,
> follow the wizard to the Database Engine components page, select the
> Full-Text index to uninstall, and click Next.
> After that, reinstall the component from your SQL Server 2005 setup CD.
> If this still cannot resolve the issue, I am afraid that you may consider
> reinstalling your SQL Server thoroughly.
>
> If you have any questions or concerns, please feel free to let me know.
> Have a good day!
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ======================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>
>|||Perhaps there's a bug in Management Studio, and it doesn't understand that Express with Advanced
serviced *does* include full text support. The "normal" express doesn't include full-text so perhaps
the designed of Management Studio decided to hide the FT stuff in the GUI when going against
Express...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jerry C" <jerryed@.nospam.nospam> wrote in message
news:73D51A31-83AA-4FE2-8CD9-D1E9ECDC4F43@.microsoft.com...
> Charles,
> Thank you for the reply,
> I have checked everything in the list.
> Step 1 Full text is in the services list and started.
> Step 2 I have run sp_fulltext_database 'enable' and it returned a success
> message.
> also the full text check box is checked in the database files page.
> Step 3 CREATE FULLTEXT CATALOG returns a success message but I connot find a
> catalog anywhere with the SQL server management studio
> Step 4 CREATE FULLTEXT INDEX ran ok using this line
> CREATE FULLTEXT INDEX ON Metadata KEY INDEX PK_Metadata
> and it returned
> A full-text index for table or indexed view 'Metadata' has already been
> created.
> (SP2) of SQL Server 2005 is installed the select @.@.Version
> Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07
> Copyright (c) 1988-2005 Microsoft Corporation Express Edition with Advanced
> Services on Windows NT 5.2 (Build 3790: Service Pack 2)
> I will do the reinstall today and see if it helps.
> Tibor, Thank you for your reply, this is the about information for this
> install.
> Microsoft SQL Server Management Studio 9.00.3042.00
> Microsoft Analysis Services Client Tools 2005.090.3042.00
> Microsoft Data Access Components (MDAC) 2000.086.3959.00
> (srv03_sp2_rtm.070216-1710)
> Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
> Microsoft Internet Explorer 7.0.5730.11
> Microsoft .NET Framework 2.0.50727.832
> Operating System 5.2.3790
>
> I am using sql server management studio. I expand the database and there is
> no storage section.
> Thank you
> --
> Jerry
>
> "Charles Wang[MSFT]" wrote:
>> Hi Jerry,
>> For further research, I would like to check with you whether you can
>> manually create the Full-text index on a table.
>> I recommend that you try the following:
>> 1. Ensure Microsoft Full-Text Engine has been installed. You can check this
>> from your computer Services list. The service name is SQL Server FullText
>> Search (MSSQLSERVER).
>> 2. Enable your database to using Full-text indexing via SSMS or running
>> sp_fulltext_database 'enable'.
>> 3. Manually run CREATE FULLTEXT CATALOG to create a catalog for storing
>> full-text indexes. For more information and samples, please refer to CREATE
>> FULLTEXT CATALOG (Transact-SQL) in SQL Server 2005 Books Online.
>> 4. Manually run CREATE FULLTEXT INDEX to create a full-text index on a
>> table. For more information and samples, please refer to CREATE FULLTEXT
>> INDEX in SQL Server 2005 Books Online.
>> If you can manually create the full-text index, but you still could not see
>> the full-text selection when you right click the table. I would like to
>> check with you the following information:
>> 1. Has the latest service pack (SP2) of SQL Server 2005 been installed to
>> the instance of your SQL Server 2005 Standard Edition? (Run SELECT
>> @.@.VERSION)
>> If not, please try installing the SP2 to see if it helps. You can
>> download it from:
>> Microsoft SQL Server 2005 Service Pack 2
>> https://www.microsoft.com/downloads/details.aspx?familyid=D07219B2-1E23-49C8
>> -8F0C-63FA18F26D3A&displaylang=en
>> 2. Did this issue occur on your other machine with the SQL Server 2005
>> Edition?
>> If installing SP2 could not solve the problem, please check if you can
>> reproduce this issue on other machine. If this issue could not be
>> reproduced, you may consider uninstalling/reinstalling Full-Text index
>> component under Database Engine to see if it helps.
>> From Control Panel, click Add or Remove Programs, select SQL Server
>> 2005, click Change, select SQL Server 2005 Instances-> "MSSQLSERVER:
>> Database Engine,...", click Next, select Database Engine, click Next,
>> follow the wizard to the Database Engine components page, select the
>> Full-Text index to uninstall, and click Next.
>> After that, reinstall the component from your SQL Server 2005 setup CD.
>> If this still cannot resolve the issue, I am afraid that you may consider
>> reinstalling your SQL Server thoroughly.
>>
>> If you have any questions or concerns, please feel free to let me know.
>> Have a good day!
>> Best regards,
>> Charles Wang
>> Microsoft Online Community Support
>> ======================================================>> When responding to posts, please "Reply to Group" via
>> your newsreader so that others may learn and benefit
>> from this issue.
>> ======================================================>> This posting is provided "AS IS" with no warranties, and confers no rights.
>> ======================================================>>
>>
>>|||FWIW, the SQL Server Management Studio Express does not have GUI support
for FT stuff either. The online tutorial at Microsoft walks you through the
commands. See video 13 at:
http://msdn2.microsoft.com/en-us/express/aa718391.aspx
RLF
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:C0FB3D8E-9BB7-451C-B8F9-8DA7569C93A0@.microsoft.com...
> Perhaps there's a bug in Management Studio, and it doesn't understand that
> Express with Advanced serviced *does* include full text support. The
> "normal" express doesn't include full-text so perhaps the designed of
> Management Studio decided to hide the FT stuff in the GUI when going
> against Express...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Jerry C" <jerryed@.nospam.nospam> wrote in message
> news:73D51A31-83AA-4FE2-8CD9-D1E9ECDC4F43@.microsoft.com...
>> Charles,
>> Thank you for the reply,
>> I have checked everything in the list.
>> Step 1 Full text is in the services list and started.
>> Step 2 I have run sp_fulltext_database 'enable' and it returned a success
>> message.
>> also the full text check box is checked in the database files page.
>> Step 3 CREATE FULLTEXT CATALOG returns a success message but I connot
>> find a
>> catalog anywhere with the SQL server management studio
>> Step 4 CREATE FULLTEXT INDEX ran ok using this line
>> CREATE FULLTEXT INDEX ON Metadata KEY INDEX PK_Metadata
>> and it returned
>> A full-text index for table or indexed view 'Metadata' has already been
>> created.
>> (SP2) of SQL Server 2005 is installed the select @.@.Version
>> Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007
>> 22:47:07
>> Copyright (c) 1988-2005 Microsoft Corporation Express Edition with
>> Advanced
>> Services on Windows NT 5.2 (Build 3790: Service Pack 2)
>> I will do the reinstall today and see if it helps.
>> Tibor, Thank you for your reply, this is the about information for this
>> install.
>> Microsoft SQL Server Management Studio 9.00.3042.00
>> Microsoft Analysis Services Client Tools 2005.090.3042.00
>> Microsoft Data Access Components (MDAC) 2000.086.3959.00
>> (srv03_sp2_rtm.070216-1710)
>> Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
>> Microsoft Internet Explorer 7.0.5730.11
>> Microsoft .NET Framework 2.0.50727.832
>> Operating System 5.2.3790
>>
>> I am using sql server management studio. I expand the database and there
>> is
>> no storage section.
>> Thank you
>> --
>> Jerry
>>
>> "Charles Wang[MSFT]" wrote:
>> Hi Jerry,
>> For further research, I would like to check with you whether you can
>> manually create the Full-text index on a table.
>> I recommend that you try the following:
>> 1. Ensure Microsoft Full-Text Engine has been installed. You can check
>> this
>> from your computer Services list. The service name is SQL Server
>> FullText
>> Search (MSSQLSERVER).
>> 2. Enable your database to using Full-text indexing via SSMS or running
>> sp_fulltext_database 'enable'.
>> 3. Manually run CREATE FULLTEXT CATALOG to create a catalog for storing
>> full-text indexes. For more information and samples, please refer to
>> CREATE
>> FULLTEXT CATALOG (Transact-SQL) in SQL Server 2005 Books Online.
>> 4. Manually run CREATE FULLTEXT INDEX to create a full-text index on a
>> table. For more information and samples, please refer to CREATE FULLTEXT
>> INDEX in SQL Server 2005 Books Online.
>> If you can manually create the full-text index, but you still could not
>> see
>> the full-text selection when you right click the table. I would like to
>> check with you the following information:
>> 1. Has the latest service pack (SP2) of SQL Server 2005 been installed
>> to
>> the instance of your SQL Server 2005 Standard Edition? (Run SELECT
>> @.@.VERSION)
>> If not, please try installing the SP2 to see if it helps. You can
>> download it from:
>> Microsoft SQL Server 2005 Service Pack 2
>> https://www.microsoft.com/downloads/details.aspx?familyid=D07219B2-1E23-49C8
>> -8F0C-63FA18F26D3A&displaylang=en
>> 2. Did this issue occur on your other machine with the SQL Server 2005
>> Edition?
>> If installing SP2 could not solve the problem, please check if you
>> can
>> reproduce this issue on other machine. If this issue could not be
>> reproduced, you may consider uninstalling/reinstalling Full-Text index
>> component under Database Engine to see if it helps.
>> From Control Panel, click Add or Remove Programs, select SQL Server
>> 2005, click Change, select SQL Server 2005 Instances-> "MSSQLSERVER:
>> Database Engine,...", click Next, select Database Engine, click Next,
>> follow the wizard to the Database Engine components page, select the
>> Full-Text index to uninstall, and click Next.
>> After that, reinstall the component from your SQL Server 2005 setup
>> CD.
>> If this still cannot resolve the issue, I am afraid that you may
>> consider
>> reinstalling your SQL Server thoroughly.
>>
>> If you have any questions or concerns, please feel free to let me know.
>> Have a good day!
>> Best regards,
>> Charles Wang
>> Microsoft Online Community Support
>> ======================================================>> When responding to posts, please "Reply to Group" via
>> your newsreader so that others may learn and benefit
>> from this issue.
>> ======================================================>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> ======================================================>>
>>
>>
>|||Charles and Tibor,
I have another machine without this problem the versions of management
studio are below.
Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Thank you
Jerry
"Charles Wang[MSFT]" wrote:
> Hi Jerry,
> For further research, I would like to check with you whether you can
> manually create the Full-text index on a table.
> I recommend that you try the following:
> 1. Ensure Microsoft Full-Text Engine has been installed. You can check this
> from your computer Services list. The service name is SQL Server FullText
> Search (MSSQLSERVER).
> 2. Enable your database to using Full-text indexing via SSMS or running
> sp_fulltext_database 'enable'.
> 3. Manually run CREATE FULLTEXT CATALOG to create a catalog for storing
> full-text indexes. For more information and samples, please refer to CREATE
> FULLTEXT CATALOG (Transact-SQL) in SQL Server 2005 Books Online.
> 4. Manually run CREATE FULLTEXT INDEX to create a full-text index on a
> table. For more information and samples, please refer to CREATE FULLTEXT
> INDEX in SQL Server 2005 Books Online.
> If you can manually create the full-text index, but you still could not see
> the full-text selection when you right click the table. I would like to
> check with you the following information:
> 1. Has the latest service pack (SP2) of SQL Server 2005 been installed to
> the instance of your SQL Server 2005 Standard Edition? (Run SELECT
> @.@.VERSION)
> If not, please try installing the SP2 to see if it helps. You can
> download it from:
> Microsoft SQL Server 2005 Service Pack 2
> https://www.microsoft.com/downloads/details.aspx?familyid=D07219B2-1E23-49C8
> -8F0C-63FA18F26D3A&displaylang=en
> 2. Did this issue occur on your other machine with the SQL Server 2005
> Edition?
> If installing SP2 could not solve the problem, please check if you can
> reproduce this issue on other machine. If this issue could not be
> reproduced, you may consider uninstalling/reinstalling Full-Text index
> component under Database Engine to see if it helps.
> From Control Panel, click Add or Remove Programs, select SQL Server
> 2005, click Change, select SQL Server 2005 Instances-> "MSSQLSERVER:
> Database Engine,...", click Next, select Database Engine, click Next,
> follow the wizard to the Database Engine components page, select the
> Full-Text index to uninstall, and click Next.
> After that, reinstall the component from your SQL Server 2005 setup CD.
> If this still cannot resolve the issue, I am afraid that you may consider
> reinstalling your SQL Server thoroughly.
>
> If you have any questions or concerns, please feel free to let me know.
> Have a good day!
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ======================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>
>|||Perhaps SSMS originally showed FT stuff against the regular Express (which doesn't have FT), and
that was considered a but. Then this was fixed in a later build of SSMS so it doesn't show FT stuff
against express. That would be a good thing when going against the regular express, but would have
been a bad thing when going against express with advanced services. Just speculation, I should
add...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jerry C" <jerryed@.nospam.nospam> wrote in message
news:CF15E37B-ED04-4FA2-91B3-57C3A91833A3@.microsoft.com...
> Charles and Tibor,
> I have another machine without this problem the versions of management
> studio are below.
> Microsoft SQL Server Management Studio 9.00.1399.00
> Microsoft Analysis Services Client Tools 2005.090.1399.00
> Thank you
>
>
> --
> Jerry
>
> "Charles Wang[MSFT]" wrote:
>> Hi Jerry,
>> For further research, I would like to check with you whether you can
>> manually create the Full-text index on a table.
>> I recommend that you try the following:
>> 1. Ensure Microsoft Full-Text Engine has been installed. You can check this
>> from your computer Services list. The service name is SQL Server FullText
>> Search (MSSQLSERVER).
>> 2. Enable your database to using Full-text indexing via SSMS or running
>> sp_fulltext_database 'enable'.
>> 3. Manually run CREATE FULLTEXT CATALOG to create a catalog for storing
>> full-text indexes. For more information and samples, please refer to CREATE
>> FULLTEXT CATALOG (Transact-SQL) in SQL Server 2005 Books Online.
>> 4. Manually run CREATE FULLTEXT INDEX to create a full-text index on a
>> table. For more information and samples, please refer to CREATE FULLTEXT
>> INDEX in SQL Server 2005 Books Online.
>> If you can manually create the full-text index, but you still could not see
>> the full-text selection when you right click the table. I would like to
>> check with you the following information:
>> 1. Has the latest service pack (SP2) of SQL Server 2005 been installed to
>> the instance of your SQL Server 2005 Standard Edition? (Run SELECT
>> @.@.VERSION)
>> If not, please try installing the SP2 to see if it helps. You can
>> download it from:
>> Microsoft SQL Server 2005 Service Pack 2
>> https://www.microsoft.com/downloads/details.aspx?familyid=D07219B2-1E23-49C8
>> -8F0C-63FA18F26D3A&displaylang=en
>> 2. Did this issue occur on your other machine with the SQL Server 2005
>> Edition?
>> If installing SP2 could not solve the problem, please check if you can
>> reproduce this issue on other machine. If this issue could not be
>> reproduced, you may consider uninstalling/reinstalling Full-Text index
>> component under Database Engine to see if it helps.
>> From Control Panel, click Add or Remove Programs, select SQL Server
>> 2005, click Change, select SQL Server 2005 Instances-> "MSSQLSERVER:
>> Database Engine,...", click Next, select Database Engine, click Next,
>> follow the wizard to the Database Engine components page, select the
>> Full-Text index to uninstall, and click Next.
>> After that, reinstall the component from your SQL Server 2005 setup CD.
>> If this still cannot resolve the issue, I am afraid that you may consider
>> reinstalling your SQL Server thoroughly.
>>
>> If you have any questions or concerns, please feel free to let me know.
>> Have a good day!
>> Best regards,
>> Charles Wang
>> Microsoft Online Community Support
>> ======================================================>> When responding to posts, please "Reply to Group" via
>> your newsreader so that others may learn and benefit
>> from this issue.
>> ======================================================>> This posting is provided "AS IS" with no warranties, and confers no rights.
>> ======================================================>>
>>
>>|||Hi Jerry,
Thanks for your feedback.
I think that we got the point here. I noticed that you said that your SQL
Server 2005 was standard edition before, however from your last response it
was SQL Server 2005 Express Edition with Advanced Services. So I guess that
your current SSMS is SSMSE (SQL Server Management Studio Express) which
does not include UI features for supporting Full-text indexing. Originally
SQL Server 2005 Express did not support Full-text indexing until SQL Server
2005 Express with Advanced Services was released.
Currently in SSMSE you must manually create Full-text indexing by hand. If
you want to use the UI features, you need to install SSMS from your SQL
Server 2005 STD/ENT/DEV Edition setup CD. I think that the SSMS worked on
your other machine was not a Express edition. You can run SELECT @.@.VERSION
to check this.
There is a video regarding Full-text indexing in SQL Server 2005 Express
with Advanced Services in Microsoft site. You may refer to:
http://download.microsoft.com/download/b/3/8/b3847275-2bea-440a-8e2e-305b009
bb261/sql_13.wmv
Hope this helps. If you have any other questions or concerns, please feel
free to let us know. Have a nice day!
Best regards,
Charles Wang
Microsoft Online Community Support
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Tibor, Charles,
That must be the problem. When I checked the properties of the data base
there is a line that identifies the server as a express version. Sorry I did
not notice this long ago.
I unstalled that server and am working on installing a Standard Edition of
the server.
The problem I ran into now is the Standard Edition will not install on this
machine. The error is Unknown error.
I think I will rebuild this machine.
Thank you
--
Jerry
"Tibor Karaszi" wrote:
> Perhaps SSMS originally showed FT stuff against the regular Express (which doesn't have FT), and
> that was considered a but. Then this was fixed in a later build of SSMS so it doesn't show FT stuff
> against express. That would be a good thing when going against the regular express, but would have
> been a bad thing when going against express with advanced services. Just speculation, I should
> add...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Jerry C" <jerryed@.nospam.nospam> wrote in message
> news:CF15E37B-ED04-4FA2-91B3-57C3A91833A3@.microsoft.com...
> > Charles and Tibor,
> >
> > I have another machine without this problem the versions of management
> > studio are below.
> >
> > Microsoft SQL Server Management Studio 9.00.1399.00
> > Microsoft Analysis Services Client Tools 2005.090.1399.00
> > Thank you
> >
> >
> >
> >
> > --
> > Jerry
> >
> >
> > "Charles Wang[MSFT]" wrote:
> >
> >> Hi Jerry,
> >> For further research, I would like to check with you whether you can
> >> manually create the Full-text index on a table.
> >> I recommend that you try the following:
> >> 1. Ensure Microsoft Full-Text Engine has been installed. You can check this
> >> from your computer Services list. The service name is SQL Server FullText
> >> Search (MSSQLSERVER).
> >> 2. Enable your database to using Full-text indexing via SSMS or running
> >> sp_fulltext_database 'enable'.
> >> 3. Manually run CREATE FULLTEXT CATALOG to create a catalog for storing
> >> full-text indexes. For more information and samples, please refer to CREATE
> >> FULLTEXT CATALOG (Transact-SQL) in SQL Server 2005 Books Online.
> >> 4. Manually run CREATE FULLTEXT INDEX to create a full-text index on a
> >> table. For more information and samples, please refer to CREATE FULLTEXT
> >> INDEX in SQL Server 2005 Books Online.
> >>
> >> If you can manually create the full-text index, but you still could not see
> >> the full-text selection when you right click the table. I would like to
> >> check with you the following information:
> >> 1. Has the latest service pack (SP2) of SQL Server 2005 been installed to
> >> the instance of your SQL Server 2005 Standard Edition? (Run SELECT
> >> @.@.VERSION)
> >> If not, please try installing the SP2 to see if it helps. You can
> >> download it from:
> >> Microsoft SQL Server 2005 Service Pack 2
> >>
> >> https://www.microsoft.com/downloads/details.aspx?familyid=D07219B2-1E23-49C8
> >> -8F0C-63FA18F26D3A&displaylang=en
> >>
> >> 2. Did this issue occur on your other machine with the SQL Server 2005
> >> Edition?
> >> If installing SP2 could not solve the problem, please check if you can
> >> reproduce this issue on other machine. If this issue could not be
> >> reproduced, you may consider uninstalling/reinstalling Full-Text index
> >> component under Database Engine to see if it helps.
> >> From Control Panel, click Add or Remove Programs, select SQL Server
> >> 2005, click Change, select SQL Server 2005 Instances-> "MSSQLSERVER:
> >> Database Engine,...", click Next, select Database Engine, click Next,
> >> follow the wizard to the Database Engine components page, select the
> >> Full-Text index to uninstall, and click Next.
> >> After that, reinstall the component from your SQL Server 2005 setup CD.
> >> If this still cannot resolve the issue, I am afraid that you may consider
> >> reinstalling your SQL Server thoroughly.
> >>
> >>
> >> If you have any questions or concerns, please feel free to let me know.
> >> Have a good day!
> >>
> >> Best regards,
> >> Charles Wang
> >> Microsoft Online Community Support
> >>
> >> ======================================================> >> When responding to posts, please "Reply to Group" via
> >> your newsreader so that others may learn and benefit
> >> from this issue.
> >> ======================================================> >> This posting is provided "AS IS" with no warranties, and confers no rights.
> >> ======================================================> >>
> >>
> >>
> >>
> >>
> >>
>|||Hi Jerry,
You may try uninstalling all the SQL Server 2005 components from Add or
Remove Programs and then delete the existing legacy folders, restart your
computer and install your SQL Server 2005 STD edition.
Please note that backup your databases before you perform the above action.
If you have any other questions or concerns, please feel free to let us
know. Have a nice day!
Best regards,
Charles Wang
Microsoft Online Community Support
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

没有评论:

发表评论