Could not allocate space for object sql server
You need to do one or more of 3 things:


Increase the max file size of the file
Increase the disk space wherever your .mdf &amp; .ndf files are stored
Delete data from your database to free up space for the new object


Right click on your Database > Properties > Files. 

Here you will see the file names, file groups, path, and importantly the Autogrowth / Maxsize. If you have it set to Limited to ... then it can't grow beyond this limit. If the file is full, you will either need to change the Maxsize or delete data from your database. If the file isn't full, then your disk could is almost certainly full and you'll need to add space there.

Also, don't shrink your database in an attempt to fix this.