Hi all.

We just deployed a MS SQL 2005 server and imported som databases of
different users.
Is there any way to set at limit size on each database, like 50 MB???

Thanks for your .

Jörg

Hi sure, navigate through the database > properties > Files > limit the
size of the data files to have them th maximum size you want to assign
and set them to restricted growth. But you should be aware that
depending on your application it could stop working, so you should
better warn your database owner before the limit is reached.

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

Hi Jens.

Thanks for the quick response, I'll try.

Regards,
Jörg

"Jens" wrote:

> Hi sure, navigate through the database > properties > Files > limit the
> size of the data files to have them th maximum size you want to assign
> and set them to restricted growth. But you should be aware that
> depending on your application it could stop working, so you should
> better warn your database owner before the limit is reached.
>
> HTH, Jens K. Suessmeyer.
>
> ---
> http://www.sqlserver2005.de
> ---
>
>