I am wondering if FUll Text Indexing is suported with MS SQL Server 2000
Developer Edition on XP Pro SP2 . I have the service installed and setup. I
have created several catalogs with data but when they are done populating
they show up with an Item Count of 0 and a Unique Index of 1 despite the
fact that there are 10+ records with extremely different data in the 3
columns that are being indexed.
I am not seeing any unusual messages in the Event Viewer also. I have
uninstalled and reinstalled already and the Server is running under an
Administrator User
Hi,
Thanks for your post.
From your descriptions, I understood that you would like to know whether
Full-Text Search is support in SQL Server Dev Edition and how to implement
it. Have I understood you? Correct me if I was wrong.
Based on my scope, Full-Text Search is supported in SQL Server 2000 Dev
Edition on Windows XP Pro. See more deatiled descritption about this in the
following links
Features Supported by the Editions of SQL Server 2000
http://msdn.microsoft.com/library/de...us/architec/8_
ar_ts_1cdv.asp
For the second question, I am not sure your detailed steps on how to
implement the Full-Text Search for the Table, would you please give me more
detail information about doing so? Here is an sample doing this with SQL
Server Enterprise Manager.
1. enable a table for full-text indexing
- Expand Databases, expand the database in which the table belongs, and
then click Tables.
- In the details pane, right-click the table, click Full-Text Index Table,
and then click Define Full-Text Indexing on a Table.
2. To create a full-text catalog
- right-click the database where you want the full-text catalog.
- Click New, and then click New Full-Text Catalog.
- Complete the New Full-Text Catalog dialog box.
3. Make a Full Populating
- expand the database that contains the full-text catalog to rebuild.
- Click Full-Text Catalogs, and then right-click the specific catalog to
populate.
- Click Start Full Population
4. See whether the data had been updated
- right-click the specific catalog to review.
- Click Properties, and then click the Status, Tables, and Schedules tabs,
as appropriate.
See the following chapter in Books Online or MSDN Online for more detailed
information
Creating and Maintaining Databases -> Full-Text Indexes ->
Administering Full-Text Features Using SQL Enterprise Manager
Hope this helps and please feel free to let me know whether it works or you
need furhter help. Thank you for your patience and corporation.
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
2012年3月19日星期一
Full Text Indexing on Microsoft SQL Server 2000 with Windows XP Pro
I am wondering if FUll Text Indexing is suported with MS SQL Server 2000
Developer Edition on XP Pro SP2 . I have the service installed and setup. I
have created several catalogs with data but when they are done populating
they show up with an Item Count of 0 and a Unique Index of 1 despite the
fact that there are 10+ records with extremely different data in the 3
columns that are being indexed.
I am not seeing any unusual messages in the Event Viewer also. I have
uninstalled and reinstalled already and the Server is running under an
Administrator UserHi,
Thanks for your post.
From your descriptions, I understood that you would like to know whether
Full-Text Search is support in SQL Server Dev Edition and how to implement
it. Have I understood you? Correct me if I was wrong.
Based on my scope, Full-Text Search is supported in SQL Server 2000 Dev
Edition on Windows XP Pro. See more deatiled descritption about this in the
following links
Features Supported by the Editions of SQL Server 2000
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_
ar_ts_1cdv.asp
For the second question, I am not sure your detailed steps on how to
implement the Full-Text Search for the Table, would you please give me more
detail information about doing so? Here is an sample doing this with SQL
Server Enterprise Manager.
1. enable a table for full-text indexing
- Expand Databases, expand the database in which the table belongs, and
then click Tables.
- In the details pane, right-click the table, click Full-Text Index Table,
and then click Define Full-Text Indexing on a Table.
2. To create a full-text catalog
- right-click the database where you want the full-text catalog.
- Click New, and then click New Full-Text Catalog.
- Complete the New Full-Text Catalog dialog box.
3. Make a Full Populating
- expand the database that contains the full-text catalog to rebuild.
- Click Full-Text Catalogs, and then right-click the specific catalog to
populate.
- Click Start Full Population
4. See whether the data had been updated
- right-click the specific catalog to review.
- Click Properties, and then click the Status, Tables, and Schedules tabs,
as appropriate.
See the following chapter in Books Online or MSDN Online for more detailed
information
Creating and Maintaining Databases -> Full-Text Indexes ->
Administering Full-Text Features Using SQL Enterprise Manager
Hope this helps and please feel free to let me know whether it works or you
need furhter help. Thank you for your patience and corporation.
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||I reposted the question in news:microsoft.public.sqlserver.programming and
received a reply from Mr. Kane who point dme to a KB that while completely
unrelated showed me where to find the Auditiong options for SQL Server which
I used to pinpoint the real problem. The problem has been resolved.
""Michael Cheng [MSFT]"" wrote:
> Hi,
> Thanks for your post.
> From your descriptions, I understood that you would like to know whether
> Full-Text Search is support in SQL Server Dev Edition and how to implement
> it. Have I understood you? Correct me if I was wrong.
> Based on my scope, Full-Text Search is supported in SQL Server 2000 Dev
> Edition on Windows XP Pro. See more deatiled descritption about this in the
> following links
> Features Supported by the Editions of SQL Server 2000
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_
> ar_ts_1cdv.asp
> For the second question, I am not sure your detailed steps on how to
> implement the Full-Text Search for the Table, would you please give me more
> detail information about doing so? Here is an sample doing this with SQL
> Server Enterprise Manager.
> 1. enable a table for full-text indexing
> - Expand Databases, expand the database in which the table belongs, and
> then click Tables.
> - In the details pane, right-click the table, click Full-Text Index Table,
> and then click Define Full-Text Indexing on a Table.
> 2. To create a full-text catalog
> - right-click the database where you want the full-text catalog.
> - Click New, and then click New Full-Text Catalog.
> - Complete the New Full-Text Catalog dialog box.
> 3. Make a Full Populating
> - expand the database that contains the full-text catalog to rebuild.
> - Click Full-Text Catalogs, and then right-click the specific catalog to
> populate.
> - Click Start Full Population
> 4. See whether the data had been updated
> - right-click the specific catalog to review.
> - Click Properties, and then click the Status, Tables, and Schedules tabs,
> as appropriate.
> See the following chapter in Books Online or MSDN Online for more detailed
> information
> Creating and Maintaining Databases -> Full-Text Indexes ->
> Administering Full-Text Features Using SQL Enterprise Manager
> Hope this helps and please feel free to let me know whether it works or you
> need furhter help. Thank you for your patience and corporation.
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>|||Hi,
I have noticed that thread, it's great to hear that it was resolved and
thanks for letting me know about that:)
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
Developer Edition on XP Pro SP2 . I have the service installed and setup. I
have created several catalogs with data but when they are done populating
they show up with an Item Count of 0 and a Unique Index of 1 despite the
fact that there are 10+ records with extremely different data in the 3
columns that are being indexed.
I am not seeing any unusual messages in the Event Viewer also. I have
uninstalled and reinstalled already and the Server is running under an
Administrator UserHi,
Thanks for your post.
From your descriptions, I understood that you would like to know whether
Full-Text Search is support in SQL Server Dev Edition and how to implement
it. Have I understood you? Correct me if I was wrong.
Based on my scope, Full-Text Search is supported in SQL Server 2000 Dev
Edition on Windows XP Pro. See more deatiled descritption about this in the
following links
Features Supported by the Editions of SQL Server 2000
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_
ar_ts_1cdv.asp
For the second question, I am not sure your detailed steps on how to
implement the Full-Text Search for the Table, would you please give me more
detail information about doing so? Here is an sample doing this with SQL
Server Enterprise Manager.
1. enable a table for full-text indexing
- Expand Databases, expand the database in which the table belongs, and
then click Tables.
- In the details pane, right-click the table, click Full-Text Index Table,
and then click Define Full-Text Indexing on a Table.
2. To create a full-text catalog
- right-click the database where you want the full-text catalog.
- Click New, and then click New Full-Text Catalog.
- Complete the New Full-Text Catalog dialog box.
3. Make a Full Populating
- expand the database that contains the full-text catalog to rebuild.
- Click Full-Text Catalogs, and then right-click the specific catalog to
populate.
- Click Start Full Population
4. See whether the data had been updated
- right-click the specific catalog to review.
- Click Properties, and then click the Status, Tables, and Schedules tabs,
as appropriate.
See the following chapter in Books Online or MSDN Online for more detailed
information
Creating and Maintaining Databases -> Full-Text Indexes ->
Administering Full-Text Features Using SQL Enterprise Manager
Hope this helps and please feel free to let me know whether it works or you
need furhter help. Thank you for your patience and corporation.
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||I reposted the question in news:microsoft.public.sqlserver.programming and
received a reply from Mr. Kane who point dme to a KB that while completely
unrelated showed me where to find the Auditiong options for SQL Server which
I used to pinpoint the real problem. The problem has been resolved.
""Michael Cheng [MSFT]"" wrote:
> Hi,
> Thanks for your post.
> From your descriptions, I understood that you would like to know whether
> Full-Text Search is support in SQL Server Dev Edition and how to implement
> it. Have I understood you? Correct me if I was wrong.
> Based on my scope, Full-Text Search is supported in SQL Server 2000 Dev
> Edition on Windows XP Pro. See more deatiled descritption about this in the
> following links
> Features Supported by the Editions of SQL Server 2000
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_
> ar_ts_1cdv.asp
> For the second question, I am not sure your detailed steps on how to
> implement the Full-Text Search for the Table, would you please give me more
> detail information about doing so? Here is an sample doing this with SQL
> Server Enterprise Manager.
> 1. enable a table for full-text indexing
> - Expand Databases, expand the database in which the table belongs, and
> then click Tables.
> - In the details pane, right-click the table, click Full-Text Index Table,
> and then click Define Full-Text Indexing on a Table.
> 2. To create a full-text catalog
> - right-click the database where you want the full-text catalog.
> - Click New, and then click New Full-Text Catalog.
> - Complete the New Full-Text Catalog dialog box.
> 3. Make a Full Populating
> - expand the database that contains the full-text catalog to rebuild.
> - Click Full-Text Catalogs, and then right-click the specific catalog to
> populate.
> - Click Start Full Population
> 4. See whether the data had been updated
> - right-click the specific catalog to review.
> - Click Properties, and then click the Status, Tables, and Schedules tabs,
> as appropriate.
> See the following chapter in Books Online or MSDN Online for more detailed
> information
> Creating and Maintaining Databases -> Full-Text Indexes ->
> Administering Full-Text Features Using SQL Enterprise Manager
> Hope this helps and please feel free to let me know whether it works or you
> need furhter help. Thank you for your patience and corporation.
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>|||Hi,
I have noticed that thread, it's great to hear that it was resolved and
thanks for letting me know about that:)
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
Full Text Indexing on Microsoft SQL Server 2000 with Windows XP Pro
I am wondering if FUll Text Indexing is suported with MS SQL Server 2000
Developer Edition on XP Pro SP2 . I have the service installed and setup. I
have created several catalogs with data but when they are done populating
they show up with an Item Count of 0 and a Unique Index of 1 despite the
fact that there are 10+ records with extremely different data in the 3
columns that are being indexed.
I am not seeing any unusual messages in the Event Viewer also. I have
uninstalled and reinstalled already and the Server is running under an
Administrator UserHi,
Thanks for your post.
From your descriptions, I understood that you would like to know whether
Full-Text Search is support in SQL Server Dev Edition and how to implement
it. Have I understood you? Correct me if I was wrong.
Based on my scope, Full-Text Search is supported in SQL Server 2000 Dev
Edition on Windows XP Pro. See more deatiled descritption about this in the
following links
Features Supported by the Editions of SQL Server 2000
http://msdn.microsoft.com/library/d...-us/architec/8_
ar_ts_1cdv.asp
For the second question, I am not sure your detailed steps on how to
implement the Full-Text Search for the Table, would you please give me more
detail information about doing so? Here is an sample doing this with SQL
Server Enterprise Manager.
1. enable a table for full-text indexing
- Expand Databases, expand the database in which the table belongs, and
then click Tables.
- In the details pane, right-click the table, click Full-Text Index Table,
and then click Define Full-Text Indexing on a Table.
2. To create a full-text catalog
- right-click the database where you want the full-text catalog.
- Click New, and then click New Full-Text Catalog.
- Complete the New Full-Text Catalog dialog box.
3. Make a Full Populating
- expand the database that contains the full-text catalog to rebuild.
- Click Full-Text Catalogs, and then right-click the specific catalog to
populate.
- Click Start Full Population
4. See whether the data had been updated
- right-click the specific catalog to review.
- Click Properties, and then click the Status, Tables, and Schedules tabs,
as appropriate.
See the following chapter in Books Online or MSDN Online for more detailed
information
Creating and Maintaining Databases -> Full-Text Indexes ->
Administering Full-Text Features Using SQL Enterprise Manager
Hope this helps and please feel free to let me know whether it works or you
need furhter help. Thank you for your patience and corporation.
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
Developer Edition on XP Pro SP2 . I have the service installed and setup. I
have created several catalogs with data but when they are done populating
they show up with an Item Count of 0 and a Unique Index of 1 despite the
fact that there are 10+ records with extremely different data in the 3
columns that are being indexed.
I am not seeing any unusual messages in the Event Viewer also. I have
uninstalled and reinstalled already and the Server is running under an
Administrator UserHi,
Thanks for your post.
From your descriptions, I understood that you would like to know whether
Full-Text Search is support in SQL Server Dev Edition and how to implement
it. Have I understood you? Correct me if I was wrong.
Based on my scope, Full-Text Search is supported in SQL Server 2000 Dev
Edition on Windows XP Pro. See more deatiled descritption about this in the
following links
Features Supported by the Editions of SQL Server 2000
http://msdn.microsoft.com/library/d...-us/architec/8_
ar_ts_1cdv.asp
For the second question, I am not sure your detailed steps on how to
implement the Full-Text Search for the Table, would you please give me more
detail information about doing so? Here is an sample doing this with SQL
Server Enterprise Manager.
1. enable a table for full-text indexing
- Expand Databases, expand the database in which the table belongs, and
then click Tables.
- In the details pane, right-click the table, click Full-Text Index Table,
and then click Define Full-Text Indexing on a Table.
2. To create a full-text catalog
- right-click the database where you want the full-text catalog.
- Click New, and then click New Full-Text Catalog.
- Complete the New Full-Text Catalog dialog box.
3. Make a Full Populating
- expand the database that contains the full-text catalog to rebuild.
- Click Full-Text Catalogs, and then right-click the specific catalog to
populate.
- Click Start Full Population
4. See whether the data had been updated
- right-click the specific catalog to review.
- Click Properties, and then click the Status, Tables, and Schedules tabs,
as appropriate.
See the following chapter in Books Online or MSDN Online for more detailed
information
Creating and Maintaining Databases -> Full-Text Indexes ->
Administering Full-Text Features Using SQL Enterprise Manager
Hope this helps and please feel free to let me know whether it works or you
need furhter help. Thank you for your patience and corporation.
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
2012年2月19日星期日
fts SQL Server Personal on XP Pro
Hi,
I have SQL Server 2000 Personal edition installed on XP
Pro and am trying to implement the full-text search
facility. There doesn't seem to be any option to install
fts on my SQL Server CD so I assumed it should be
installed by default.
However, when I try
EXEC sp_fulltext_database @.action = 'Enable'
I get the following error
erver: Msg 7609, Level 17, State 2, Procedure
sp_fulltext_database, Line 46
Full-Text Search is not installed, or a full-text
component cannot be loaded.
Is FTS possible with this version of SQLServer?
thanks
Maracatu
maracatu,
No, the SQL Server 2000 "Full-Text Search" components are not supported with
the Personal Edition. See SQL 2000 BOL title "Features Supported by the
Editions of SQL Server 2000" for editions that support SQL FTS.
Regards,
John
"maracatu" <jarrod@.dovelight.com> wrote in message
news:1ccfa01c42241$c5b48fe0$a101280a@.phx.gbl...
> Hi,
> I have SQL Server 2000 Personal edition installed on XP
> Pro and am trying to implement the full-text search
> facility. There doesn't seem to be any option to install
> fts on my SQL Server CD so I assumed it should be
> installed by default.
> However, when I try
> EXEC sp_fulltext_database @.action = 'Enable'
> I get the following error
> erver: Msg 7609, Level 17, State 2, Procedure
> sp_fulltext_database, Line 46
> Full-Text Search is not installed, or a full-text
> component cannot be loaded.
> Is FTS possible with this version of SQLServer?
> thanks
> Maracatu
|||Hmmmm.... This article on MSDN says that Full Text IS supported on Personal Edition...
http://msdn.microsoft.com/library/de...ar_ts_1cdv.asp
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
|||SqlJunkies User,
Hmmm is right... Actually we both referenced the same doc (your MSDN
reference is the same info that is in the SQL BOL reference I quoted...
However, the initial poster may need to specifically install the SQL FTS
components via the SQL CD's "custom installation" and select the "Full-text
Search" components in order to install it. I've not tested this myself as I
don't use the Personal Edition of SQL Server on WinXP as I use the Developer
Edition. If you have the Personal Edition, perhaps you could test this
yourself and post the results here... ;-)
Regards,
John
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:#W##QXpREHA.1276@.TK2MSFTNGP11.phx.gbl...
> Hmmmm.... This article on MSDN says that Full Text IS supported on
Personal Edition...
>
http://msdn.microsoft.com/library/de...ar_ts_1cdv.asp
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
|||I had the exact same problem. I found and posted the article mentioned in the last post. I then found article Q827449 that tells how to reinstall Full Text by running some stuff on the SQL CD. I followed all the instructions, but didn't seem to make it
work. Something still missing. Then, when running the Setup for SQL 2000 Personal Edition again (Not uninstalling my first one), and choosing a Custom Install to Add/Remove components, the option for Full Text was already checked. It would not let me
uncheck it (Setup didn't recognize that I had changed anything and wouldn't continue). Finally, had to uninstall, whack all SQL related registry keys, and reinstall. On the reinstall, chose Custom Install. Full Text is NOT checked by default. Checked
it, and finished the install. Full Text is now available and usable on my SQL 2000 Personal Edition on XP Professional. If you haven't "damaged" you SQL install by following Q827449, you might be able to add it by running Setup again and choosing Custo
m Install to Add/Remove Components...
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
|||Hi,
In order to un-check the option for Full Text Search that was already
checked, you must delete or rename the following Tracking Key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\<Instance_Name>\Tracking\
{E07FDDA7-5A21-11d2-9DAD-00C04F79D434}
Note, if your SQL Server 2000 is not a named instance, remove
"<Instance_Name>\" and be sure to be logged on to the server as either
Administrator or as a member of the server's Admin Group.
Once you've done removed (renamed) the above tracking key, then delete the
MSSearch directory from either:
drive_letter:\Program Files\Common Files\Microsoft Shared\
or
drive_letter::\Program Files\Common Files\System\
Then using your SQL Server 2000 installation CD re-install via "Custom
Installation" the Full-Text Search component (it should be un-checked). When
this completes find and save these files: SearchSetup.log (usually under
\windows or \winnt folders) and sqlsp.log. If any problems, you should post
these files.
I'm not sure why the procedures in Q827449 failed for you, but if you follow
the above procedures, it will always work as I've posted the above methods
many, many times in this newsgroup (microsoft.public.sqlserver.fulltext) and
always with successful results.
Regards,
John
<CSaalfeld@.-NOSPAM-Earthlink.net> wrote in message
news:OEdOfICSEHA.3052@.TK2MSFTNGP12.phx.gbl...
> I had the exact same problem. I found and posted the article mentioned in
the last post. I then found article Q827449 that tells how to reinstall
Full Text by running some stuff on the SQL CD. I followed all the
instructions, but didn't seem to make it work. Something still missing.
Then, when running the Setup for SQL 2000 Personal Edition again (Not
uninstalling my first one), and choosing a Custom Install to Add/Remove
components, the option for Full Text was already checked. It would not let
me uncheck it (Setup didn't recognize that I had changed anything and
wouldn't continue). Finally, had to uninstall, whack all SQL related
registry keys, and reinstall. On the reinstall, chose Custom Install. Full
Text is NOT checked by default. Checked it, and finished the install. Full
Text is now available and usable on my SQL 2000 Personal Edition on XP
Professional. If you haven't "damaged" you SQL install by following
Q827449, you might be able to add it by running Setup again and choosing
Custom Install to Add/Remove Components...
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
I have SQL Server 2000 Personal edition installed on XP
Pro and am trying to implement the full-text search
facility. There doesn't seem to be any option to install
fts on my SQL Server CD so I assumed it should be
installed by default.
However, when I try
EXEC sp_fulltext_database @.action = 'Enable'
I get the following error
erver: Msg 7609, Level 17, State 2, Procedure
sp_fulltext_database, Line 46
Full-Text Search is not installed, or a full-text
component cannot be loaded.
Is FTS possible with this version of SQLServer?
thanks
Maracatu
maracatu,
No, the SQL Server 2000 "Full-Text Search" components are not supported with
the Personal Edition. See SQL 2000 BOL title "Features Supported by the
Editions of SQL Server 2000" for editions that support SQL FTS.
Regards,
John
"maracatu" <jarrod@.dovelight.com> wrote in message
news:1ccfa01c42241$c5b48fe0$a101280a@.phx.gbl...
> Hi,
> I have SQL Server 2000 Personal edition installed on XP
> Pro and am trying to implement the full-text search
> facility. There doesn't seem to be any option to install
> fts on my SQL Server CD so I assumed it should be
> installed by default.
> However, when I try
> EXEC sp_fulltext_database @.action = 'Enable'
> I get the following error
> erver: Msg 7609, Level 17, State 2, Procedure
> sp_fulltext_database, Line 46
> Full-Text Search is not installed, or a full-text
> component cannot be loaded.
> Is FTS possible with this version of SQLServer?
> thanks
> Maracatu
|||Hmmmm.... This article on MSDN says that Full Text IS supported on Personal Edition...
http://msdn.microsoft.com/library/de...ar_ts_1cdv.asp
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
|||SqlJunkies User,
Hmmm is right... Actually we both referenced the same doc (your MSDN
reference is the same info that is in the SQL BOL reference I quoted...
However, the initial poster may need to specifically install the SQL FTS
components via the SQL CD's "custom installation" and select the "Full-text
Search" components in order to install it. I've not tested this myself as I
don't use the Personal Edition of SQL Server on WinXP as I use the Developer
Edition. If you have the Personal Edition, perhaps you could test this
yourself and post the results here... ;-)
Regards,
John
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:#W##QXpREHA.1276@.TK2MSFTNGP11.phx.gbl...
> Hmmmm.... This article on MSDN says that Full Text IS supported on
Personal Edition...
>
http://msdn.microsoft.com/library/de...ar_ts_1cdv.asp
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
|||I had the exact same problem. I found and posted the article mentioned in the last post. I then found article Q827449 that tells how to reinstall Full Text by running some stuff on the SQL CD. I followed all the instructions, but didn't seem to make it
work. Something still missing. Then, when running the Setup for SQL 2000 Personal Edition again (Not uninstalling my first one), and choosing a Custom Install to Add/Remove components, the option for Full Text was already checked. It would not let me
uncheck it (Setup didn't recognize that I had changed anything and wouldn't continue). Finally, had to uninstall, whack all SQL related registry keys, and reinstall. On the reinstall, chose Custom Install. Full Text is NOT checked by default. Checked
it, and finished the install. Full Text is now available and usable on my SQL 2000 Personal Edition on XP Professional. If you haven't "damaged" you SQL install by following Q827449, you might be able to add it by running Setup again and choosing Custo
m Install to Add/Remove Components...
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
|||Hi,
In order to un-check the option for Full Text Search that was already
checked, you must delete or rename the following Tracking Key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\<Instance_Name>\Tracking\
{E07FDDA7-5A21-11d2-9DAD-00C04F79D434}
Note, if your SQL Server 2000 is not a named instance, remove
"<Instance_Name>\" and be sure to be logged on to the server as either
Administrator or as a member of the server's Admin Group.
Once you've done removed (renamed) the above tracking key, then delete the
MSSearch directory from either:
drive_letter:\Program Files\Common Files\Microsoft Shared\
or
drive_letter::\Program Files\Common Files\System\
Then using your SQL Server 2000 installation CD re-install via "Custom
Installation" the Full-Text Search component (it should be un-checked). When
this completes find and save these files: SearchSetup.log (usually under
\windows or \winnt folders) and sqlsp.log. If any problems, you should post
these files.
I'm not sure why the procedures in Q827449 failed for you, but if you follow
the above procedures, it will always work as I've posted the above methods
many, many times in this newsgroup (microsoft.public.sqlserver.fulltext) and
always with successful results.
Regards,
John
<CSaalfeld@.-NOSPAM-Earthlink.net> wrote in message
news:OEdOfICSEHA.3052@.TK2MSFTNGP12.phx.gbl...
> I had the exact same problem. I found and posted the article mentioned in
the last post. I then found article Q827449 that tells how to reinstall
Full Text by running some stuff on the SQL CD. I followed all the
instructions, but didn't seem to make it work. Something still missing.
Then, when running the Setup for SQL 2000 Personal Edition again (Not
uninstalling my first one), and choosing a Custom Install to Add/Remove
components, the option for Full Text was already checked. It would not let
me uncheck it (Setup didn't recognize that I had changed anything and
wouldn't continue). Finally, had to uninstall, whack all SQL related
registry keys, and reinstall. On the reinstall, chose Custom Install. Full
Text is NOT checked by default. Checked it, and finished the install. Full
Text is now available and usable on my SQL 2000 Personal Edition on XP
Professional. If you haven't "damaged" you SQL install by following
Q827449, you might be able to add it by running Setup again and choosing
Custom Install to Add/Remove Components...
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
FTS Over SQL Personal Edition
I have several instances of SQL Server 2000 Personal Edition running on 2000
Pro and XP Pro.
Are there any issues with installing Full-Text Search on these machines?
Thanks
hi ray!
"Binder" <rgondzur@.NO_SPAM_aicsoft.com> wrote in message
news:%23k4Erl4XEHA.3044@.TK2MSFTNGP09.phx.gbl...
> I have several instances of SQL Server 2000 Personal Edition running on
2000
> Pro and XP Pro.
> Are there any issues with installing Full-Text Search on these machines?
> Thanks
>
|||Binder,
If you review SQL 2000 BOL title "Features Supported by the Editions of SQL
Server 2000", it states that for the Personal Edition that Full-Text Search
is "Supported (except on Windows 98)". However, and while I've not tested
this with the Personal Edition (as I have with the Developer Edition), to
install FTS you must select "custom installation" from your SQL CD and under
the Server components, select the "Full-text Search" components and it
*should* install SQL FTS. No, to the best of my knowledge, there should not
be any installation issue with installing Full-Text Search on those
machines. However, I'd recommend that you be logged on as either Admin or as
a member of the Admin Group when you do the custom installation.
Regards,
John
"Binder" <rgondzur@.NO_SPAM_aicsoft.com> wrote in message
news:#k4Erl4XEHA.3044@.TK2MSFTNGP09.phx.gbl...
> I have several instances of SQL Server 2000 Personal Edition running on
2000
> Pro and XP Pro.
> Are there any issues with installing Full-Text Search on these machines?
> Thanks
>
Pro and XP Pro.
Are there any issues with installing Full-Text Search on these machines?
Thanks
hi ray!
"Binder" <rgondzur@.NO_SPAM_aicsoft.com> wrote in message
news:%23k4Erl4XEHA.3044@.TK2MSFTNGP09.phx.gbl...
> I have several instances of SQL Server 2000 Personal Edition running on
2000
> Pro and XP Pro.
> Are there any issues with installing Full-Text Search on these machines?
> Thanks
>
|||Binder,
If you review SQL 2000 BOL title "Features Supported by the Editions of SQL
Server 2000", it states that for the Personal Edition that Full-Text Search
is "Supported (except on Windows 98)". However, and while I've not tested
this with the Personal Edition (as I have with the Developer Edition), to
install FTS you must select "custom installation" from your SQL CD and under
the Server components, select the "Full-text Search" components and it
*should* install SQL FTS. No, to the best of my knowledge, there should not
be any installation issue with installing Full-Text Search on those
machines. However, I'd recommend that you be logged on as either Admin or as
a member of the Admin Group when you do the custom installation.
Regards,
John
"Binder" <rgondzur@.NO_SPAM_aicsoft.com> wrote in message
news:#k4Erl4XEHA.3044@.TK2MSFTNGP09.phx.gbl...
> I have several instances of SQL Server 2000 Personal Edition running on
2000
> Pro and XP Pro.
> Are there any issues with installing Full-Text Search on these machines?
> Thanks
>
订阅：
博文 (Atom)