Link to home
Start Free TrialLog in
Avatar of Karen Schaefer
Karen SchaeferFlag for United States of America

asked on

creating classifer function - Sql Server 2012

I am going thru a tutorial on how to create a Resource Pool.  I create the Function MyClassifier()
Then
Click REsource Governor/ResourcePools/Create New Pool.

Dialog opens,

Click Enable Resource Governor and the Drop down only displays (None).

Where is the the classifer I just created?  

When I tried the function execution it states "Msg 2714, Level 16, State 3, Procedure myClassifer, Line 1
There is already an object named 'myClassifer' in the database."

So where did it go?

K


User generated image
Avatar of LajuanTaylor
LajuanTaylor

Did you check to see if your function was created in the AdventureWorks database versus the "Master" system database?

Check in the database tree nodes "Programmability" under "Scalar-valued Functions"
SOLUTION
Avatar of LajuanTaylor
LajuanTaylor

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Karen Schaefer

ASKER

thanks for the input.