Is it possible to apply restrictions on how much data a user / login may store in a database? I found no way to apply such restrictions to schemas, for instance.
If there is no built-in mechanism then I'm curious if someone had implemented some kind of it.
Seems a bit ridiculous, I know but we have some users and want them to restrict writing too much data into
WorkDB so that their activities (queries, inserts) wouldn't eat out all the resources.
Resource Governor can only maintain CPU/RAM.
Environment: SQL Server 2008 R2 Enterprise edition.