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
More Information About Unlimited Shared Windows Hosting Plan

Windows Hyper-V Server

Dedicated Memory:2GB
Disk Space: 200GB
Bandwidth: Unlimited
Windows 2008/2003: Free
Monthly: $49.99
More Information About Unlimited Windows Hyper-V Server

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
More Information About Unlimited Dedicated SQL Server