SQL Server Errors or Failures from Error: 7414 to Error: 7642



Error: 7614, Severity: 16, Cannot alter or drop column ‘%.*ls’ because it is enabled for Full-Text Search.
Error: 7615, Severity: 16, A CONTAINS or FREETEXT predicate can only operate on one table or indexed view. Qualify the use of * with a table or indexed view name.
Error: 7616, Severity: 16, Full-Text Search is not enabled for the current database. Use sp_fulltext_database to enable full-text search for the database. The functionality to disable and enable full-text search for a database is deprecated. Please change your application.
Error: 7617, Severity: 16, Query does not reference the full-text indexed table or indexed view, or user does not have permission to perform this action.

Error: 7619, Severity: 16, The execution of a full-text query failed. “%ls”
Error: 7620, Severity: 16, The conversion to data type %ls failed for the full-text search key.
Error: 7621, Severity: 16, Invalid use of full-text predicate in the HAVING clause.
Error: 7622, Severity: 17, There is not sufficient disk space to complete this operation for the full-text catalog “%ls”.
Error: 7624, Severity: 16, Full-text catalog ‘%ls’ is in an unusable state. Drop and re-create this full-text catalog.
Error: 7625, Severity: 16, Full-text table or indexed view has more than one LCID among its full-text indexed columns.

Error: 7626, Severity: 15, The top_n_by_rank argument (‘%d’) must be greater than or equal to zero.
Error: 7627, Severity: 16, Cannot create the full-text catalog in the directory “%.*ls” for the clustered server. Only directories on a disk in the cluster group of the server can be used.
Error: 7629, Severity: 17, Cannot open or query the full-text default path registry key. The full-text default catalog path is invalid.
Error: 7630, Severity: 15, Syntax error near ‘%.*ls’ in the full-text search condition ‘%.*ls’.
Error: 7632, Severity: 15, The value of the Weight argument must be between 0.0 and 1.0.
Error: 7636, Severity: 10, Warning: Request to start a full-text index population on table or indexed view ‘%.*ls’ is ignored because a population is currently active for this table or indexed view.
Error: 7638, Severity: 10, Warning: Request to stop change tracking has deleted all changes tracked on table or indexed view ‘%ls’.
Error: 7640, Severity: 10, Warning: Request to stop tracking changes on table or indexed view ‘%.*ls’ will not stop population currently in progress on the table or indexed view.
Error: 7641, Severity: 16, Full-Text catalog ‘%ls’ does not exist in database ‘%.*ls’ or user does not have permission to perform this action.
Error: 7642, Severity: 16, A full-text catalog named ‘%ls’ already exists in this database. Use a different name.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.


Leave a Reply

Your email address will not be published. Required fields are marked *