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];
No comments:
Post a Comment