All geek questions in one place

Creating a complete text index error

I am trying to create a full text index, but I get an error that you can see on the screen below:

enter image description here

Any idea what could be the reason? Thanks Laziale

+4
source share
2 answers

This is apparently a resolution issue

See the response to Server Error:

How to get permission to create a full-text index?

If you have permission from the owner of the database, all you need to do is.

Full-text indexing is an option in the SQL Server installer. You may need to go back and add a function.

In addition, these instructions should take care of you:

http://sqlserverpedia.com/wiki/FTS_-_How_to_use_TSQL_to_Create_Full-Text_Indexes

+3
source

Yes, that is right. Read the error message: "The full-text catalog does not exist by default or the user does not have permission to perform this action." I'm not sure how anyone can make this more clear. :)

You need to use CREATE FULLTEXT CATALOG to create a default full-text directory before you can CREATE FULLTEXT INDEX into this directory. If you have done this, you need to make sure that the user has GRANT permissions that allow you to create full-text indexes.

See SQL Server CREATE FULLTEXT CATALOG (BOL) and finding a CREATE FULLTEXT CATALOG in an index. Or you can use this link to install BOL locally.

0
source

Source: https://habr.com/ru/post/1402973/

More articles:


All Articles