• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2491
  • Last Modified:

Drop Failed: Te database principal owns a fulltext catalog in the database

Hello,

I moved a SQL Server 2005 database to SQL Server and the account has lost its password. So, I tried dropping it and recreating it in the database. I get the error:

Drop failed for User 'dba'.  (Microsoft.SqlServer.Smo)
The database principal owns a fulltext catalog in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138)

I have about 20 fulltext catalog's in the database. Which owner would I use in the script below?

sp_changeobjectowner  'app_facility_catalog', [ @newowner = ] 'owner'

Thanks.



0
gtrapp
Asked:
gtrapp
  • 2
1 Solution
 
gtrappAuthor Commented:
Hi,

Yes, I saw that, but wondering what I put as the owner when I run the script.
0
 
gtrappAuthor Commented:
Thanks, I got it fixed by running this:

exec sp_change_users_login 'Auto_Fix', 'dba'
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now