Problem with disk space sql server 2008

I开发者_Python百科m executing query but there is an error:

Could not allocate space for object 'dbo.User2User'.'IX_User2Id' in database 'MyDatabase' because the 'PRIMARY' filegroup is full.

Is enabled autogrowth by 10 MB without any restrictions on size.

Thanks for any ideas how to cope with that

---

If this physical disk is not full and you are sure that you have restricted the file size within SQL then I would imagine that you are using Express version.

Express Version has a 10GB Database limit.

Compare SQL Editions