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

[Blog bot]

Источник: http://d365technext.blogspot.com/201...-fulltext.html
==============




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];







Источник: http://d365technext.blogspot.com/201...-fulltext.html