Friday, March 30, 2012

Resource Limits ?

In Oracle & Sybase you can set login resource limits to restrict, time of day, number of i-o's, cpu use etc for any login, at the login method. All actions done from a resource limit constrained login inherit the constraints.

Is there any way to implment this with any MS SQL Server version from 200-2005/SP2?

Before anyone answers, please do not suggest set rowcount etc.
thanks.I don't see this kind of feature available yet in any of the versions of SQL Server, however workaround are the only possible methods like the one you have suggested.sql

No comments:

Post a Comment