Failing to change the owner of a full text catalog

• pbyrum

  SSCrazy

  Points: 2785

  More actions

  October 29, 2015 at 11:51 am

  #321874

  Hello,

  I am having troubles to change an owner of a full text catalog. I am the owner of the database. I am doing this:

  USE database;

  ALTER AUTHORIZATION ON Fulltext Catalog::[ftrow_code_lookup_catalog] TO [dbo];

  Logical Name: ftrow_app_facility_catalog

  FileGroup: ftfg_app_facility_catalog

  But I get an error:

  Cannot find the fulltext catalog 'ftrow_app_facility_catalog', because it does not exist or you do not have permission.

  Thanks.

• Jayanth_Kurup

  SSC-Insane

  Points: 22967

  More actions

  October 29, 2015 at 12:03 pm

  #1836481

  whats the output of this query

  select * from sys.fulltext_catalogs

  Jayanth Kurup[/url]

• pbyrum

  SSCrazy

  Points: 2785

  More actions

  October 29, 2015 at 12:14 pm

  #1836487

  Different names that work! Thanks.