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
0 comments:
Post a Comment