How to change the owner of SQL Server fulltext catalog? The database principal owns a fulltext catalog in the database and cannot be dropped
Problem
You got the following error message when you tried to delete a user from the database in SQL Server.
Msg 15138, Level 16, State 1, Line 1
The database principal owns a fulltext catalog in the database, and cannot be dropped.
Solution
You need to change the owner of fulltext catalog to "dbo".
ALTER AUTHORIZATION ON Fulltext Catalog::[CatalogName] TO [dbo];
Navigator
Other Knowledgebase Articles
Basic SQL Hosting
# of Domains:
4
# of SQL Server Databases:
4
Disk Space:
50GB
Bandwidth:
Unmetered
SQL Server 2016
Monthly:
$4.99
Express Hyper-V Hosting
Dedicated Memory:
2GB
Disk Space:
120GB
Bandwidth:
Unmetered
Windows 2016/2012:
Free
Monthly:
$11.99
Dedicated SQL Server
CPU:
Quad-Core X3440 CPU
RAM:
16GB RAM
Disk:
2x120GB SSD + 300GB SATA
RAID:
RAID 1
Bandwidth:
Unmetered
Windows 2016/2012:
Free
Monthly:
$79.00