0 How to fix: Msg 10920, Level 16, State 3, Line 71

While dropping the function, I get the error:

Msg 10920, Level 16, State 3, Line 71
Cannot drop user-defined function 'fx_DBAClassifierFunction'. It is being used as a resource governor classifier.

In order to successfully drop it, we have to disable the resource governor first .

USE Master

GO

ALTER RESOURCE GOVERNOR WITH (CLASSIFIER_FUNCTION = NULL)

GO

ALTER RESOURCE GOVERNOR DISABLE

GO

DROP FUNCTION dbo.fx_DBAClassifierFunction

GO