Karen Schaefer
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/Cre ate 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
Then
Click REsource Governor/ResourcePools/Cre
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks for the input.
Check in the database tree nodes "Programmability" under "Scalar-valued Functions"