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