I had an hosted SQL Server Database, the hosting company had an limit of 200 MB for each db.
Then I moved to another hosting company which had virtually no such limit.
I backed up database and restored to new hosting.
After few days, my database crossed 200MB and all my queries were failing.
I noticed the database still had limit of 200MB,
Changing the limit via Management Stuido did not help ( as it was not showing up the File Option )
So here is the statement which helped me.
ALTER DATABASE [dbName] MODIFY FILE ( NAME = N’DB_Name_data’, MAXSIZE = UNLIMITED)