Wednesday, March 07, 2012 6:19 AM
I am getting the following error whenever i try to run the stored procedure
Could not allocate space for object 'sys.sysrscols'.'clust' in database 'ABCDEFG' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
Thanks In Advance
- Edited by AjayChauhan0408 Wednesday, March 07, 2012 6:23 AM
Wednesday, March 07, 2012 6:24 AM
Wednesday, March 07, 2012 6:25 AMAnswererIt is possible that during some DML operation the file has to be grown to specific size and there was no space on disk....
Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
- Marked As Answer by KJian_ Wednesday, March 14, 2012 2:00 AM
Wednesday, March 07, 2012 6:31 AMModerator
Do you have a space problem?
If yes, do as suggested above: cleanup, add additional file(s).
Kalman Toth, SQL Server & Business Intelligence Training; SQL SERVER BEST PRACTICES
Wednesday, March 07, 2012 12:43 PM
Probably the database files don't have autogrowth settings well configured
Try below script to get this info from all databases