Drop User error in SQL 2005

Posted on 2007-10-04
Last Modified: 2008-01-09
I am trying to drop a user in SQL 2005 with the following script.

USE [CentrePointSoftware]
/****** Object:  User [MASTER]    Script Date: 10/04/2007 16:24:56 ******/
IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = N'MASTER')

I receive error:
Msg 15138, Level 16, State 1, Line 1
The database principal owns a fulltext catalog in the database, and cannot be dropped.

Any help please
Question by:Shezad Ahmed
    LVL 27

    Accepted Solution

    You must change the ownership of any object owned by the user before you can drop the user.


    sp_changeobjectowner [ @objname = ] 'object' , [ @newowner = ] 'owner'


    EXEC sp_changeobjectowner 'authors', 'Corporate\GeorgeW';

    LVL 27

    Assisted Solution

    You could also drop the full-text catalog and then drop the user


    To remove a full-text catalog from a database
    In Object Explorer, expand the server group, expand Databases, and expand the database that contains the full-text catalog you want to remove.

    Expand Storage, and expand Full Text Catalogs.

    Right-click the full-text catalog that you want to remove, and then select Delete.

    In the Delete Objects dialog box, click OK.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Join & Write a Comment

    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now