The database principal owns a fulltext catalog in the database, and cannot be dropped.

The database principal owns a fulltext catalog in the database, and cannot be dropped.

Problem

Msg 15138, Level 16, State 1, Line 1

    The database principal owns a fulltext catalog in the database, and cannot be dropped.

Resolution 

Find the catalog name and change the owner ship like below

Run the command on your database 

select * from sys.fulltext_catalogs

Now change the ownership with below script

Example

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

Script should be in my case like

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

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

Support Faryal's Cusine

Private, Protected and Public attribute access in Class Extension

Private, Protected, and Public attribute access in Class Extension

lots of developers faced the issue on the daily basis during development to access private, protected, and public methods.

As everyone knows that public attribute is available to access with the class instance.
but protected and private attributes are a little difficult to access.

In this demo, we show how to access all 3 access modifiers using the class extension.


Step-1 Create a class SLD_DemoClass.
Step-2 Declare 3 variables like below and one public method to set values in these variables.

Step-3 Now create an Extension of this class with SLD_DemoClass_Extension.
Step-4 Create a getter setter to access the variable.

for public and protected methods it's easy to access just to write simple getter setter method and can access these public methods using class instance.

Step-5 To Access the private attributes in-class extension, We need to use the C# reflection library.

Step-6 Now write the below code to access the private attribute on run-time.

following is the screenshot of the complete code of the extension class.

Step-7 Now create a run-able class and action menu item to execute this code.

Step-8 perform build & Sync and login on D365FO for verification.

You can check in the screenshot all 3  protected, private, and public attributes values in the info message.

Please feel free to contact me if you are facing any issues during the implementation of this blog.

Support Faryal's Cusine