<div>
Hi,<br />
<br />
Yes, I saw that, but wondering what I put as the owner when I run the script.
</div>


Hi,

Yes, I saw that, but wondering what I put as the owner when I run the script.

<div>
Thanks, I got it fixed by running this:<br />
<br />
exec sp_change_users_login 'Auto_Fix', 'dba'
</div>


Thanks, I got it fixed by running this:

exec sp_change_users_login 'Auto_Fix', 'dba'

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
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:<br />
<br />
Drop failed for User 'dba'. &nbsp;(Microsoft.SqlServer.Smo)<br />
The database principal owns a fulltext catalog in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138)<br />
<br />
I have about 20 fulltext catalog's in the database. Which owner would I use in the script below? <br />
<br />
sp_changeobjectowner &nbsp;'app_facility_catalog', [ @newowner = ] 'owner'<br />
<br />
Thanks.<br />
<br />
<br />
<br />

</div>
</div>


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.





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

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.