SQL Server Error Code – 30034 full-text stoplist ‘%.*ls’ cannot be dro

In this blog post, you’ll learn more about the SQL Server Error Code 30034 and the error message description that is shown

SQL Server Error Code

30034

SQL Server Error Description for the Code :30034

Full-text stoplist ‘%.*ls’ cannot be dropped because it is being used by at least one full-text index. To identify which full-text index is using a stoplist: obtain the stoplist ID from the stoplist_id column of the sys.fulltext_indexes catalog view, and then look up that stoplist ID in the stoplist_id column of the sys.fulltext_stoplists catalog view. Either drop the full-text index by using DROP FULLTEXT INDEX or change its stoplist setting by using ALTER FULLTEXT INDEX. Then retry dropping the stoplist.