We help IT Professionals succeed at work.

Drop User error in SQL 2005

1,730 Views
Last Modified: 2008-01-09
I am trying to drop a user in SQL 2005 with the following script.

USE [CentrePointSoftware]
GO
/****** Object:  User [MASTER]    Script Date: 10/04/2007 16:24:56 ******/
IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = N'MASTER')
DROP USER [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
Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.