Saturday, October 11, 2014

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.

image

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

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates