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
Shared Hosting
# of Domains:
2
# of SQL Server Databases:
2
Disk Space:
Unlimited
Bandwidth:
Unlimited
Email:
Unlimited
SQL Server 2008 R2
Monthly:
$4.99
Windows Hyper-V Server
Dedicated Memory:
2GB
Disk Space:
200GB
Bandwidth:
Unlimited
Windows 2008/2003:
Free
Monthly:
$49.99
Dedicated SQL Server
CPU:
Intel Dual-Core Sandy Bridge I3-2100
RAM:
8GB RAM
Disk:
2x320GB SATA
RAID:
Host RAID 1
Bandwidth:
Unlimited
Windows 2008/2003:
Free
Monthly:
$99.00