Wednesday, March 28, 2012

How to assign quota on a specific datafile?


Hi Faculties,
Is is possible to assign space quotas on filegroup(s)/files to
database users?

*** Sent via Developersdex http://www.developersdex.com ***"debian mojo" <debian_mojo@.yahoo.com> wrote in message
news:Rj2je.879$XT1.662@.news.uswest.net...
>
> Hi Faculties,
> Is is possible to assign space quotas on filegroup(s)/files to
> database users?
>
> *** Sent via Developersdex http://www.developersdex.com ***

No - you can limit/fix the size of database files (see ALTER DATABASE), but
there is no support for quotas within a database.

Simon

No comments:

Post a Comment