The database principal owns a fulltext catalog in the database, and cannot be dropped.

The database principal owns a fulltext catalog in the database, and cannot be dropped.

Problem

Msg 15138, Level 16, State 1, Line 1

    The database principal owns a fulltext catalog in the database, and cannot be dropped.

Resolution 

Find the catalog name and change the owner ship like below

Run the command on your database 

select * from sys.fulltext_catalogs

Now change the ownership with below script

Example

ALTER AUTHORIZATION ON Fulltext Catalog::[CatalogName] TO [dbo];  

Script should be in my case like

ALTER AUTHORIZATION ON Fulltext Catalog::[COMMERCEFULLTEXTCATALOG] TO [dbo];  

ALTER AUTHORIZATION ON Fulltext Catalog::[SqlTempDBForSync_catalog] TO [dbo];  

Support Faryal's Cusine