Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
When I run a DBCC check against the database, it informs me that there is an issue with the sys.fulltext_stoplists object. It appears that the principal_id in stoplists does not have a relationship with database_principals:
What would be the best way to address the issue? It is difficult to modify data in system tables.
The sys.fulltext_stoplists doc says the column principal_id is the ID of the database principal that owns the stoplist. You can specify it as one of the Arguments of the CREATE FULLTEXT STOPLIST command:
AUTHORIZATION owner_name
Specifies the name of a database principal to own of the stoplist. owner_name must either be the name of a principal of which the current user is a member, or the current user must have IMPERSONATE permission on owner_name. If not specified, ownership is given to the current user.
It appears the owner of the object no longer exists. You can assign a new owner using the ALTER AUTHORIZATION like this:
ALTER AUTHORIZATION ON FULLTEXT STOPLIST::CustomStopword TO SomeExistingUser;
After that, run the DBCC check again to see if everything is ok.
SELECT type_desc FROM sys.database_principals WHERE name = 'maintenance'; return? 3 - Does DBCC CHECKDB; return any error? (You might wanna run this last one in your maintenance window)