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

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

How to ask a question...(MS KB Article)

MS has post a KB article on how to post a question on a online forum...

http://support.microsoft.com/kb/q555375

At first I though this was hilarious, but there is actually some good information in here that is applicable on this forum as well as anywhere else. Perhaps Brett could add this as a sticky?

Regards,

hmscottI like it.|||I liked:

Do you have current backups? Why not?

I'll go add the link