Discussion in 'SQL Server 2008 Questions [Archive Only - Closed]' started by Akthar, Mar 28, 2008.
Can we configure RG for a specific query or Stored proc instead of a User or Group?
I have tried RG for Users, but as you said Query/sp/application i have not. But what i feel is, if its not provided then we can achieve that with EXECUTE AS feature. I may be wrong..
Do you mean you can use RG to limit how much a user can utilize a resource? How do you assign users in RG? I couldn't find it.
Here is a nice example on RG by Andrew Fryer http://blogs.technet.com/andrew/archive/2007/11/25/sql-server-2008-resource-governor.aspx
AFAIK we can not configure RG for specific query/sp.
Other way round is associate a role or group to execute that stored procedure and control the resource via that phase.
I tried it but can't get success. May be there is some problem!
Separate names with a comma.