I have a table in a database that has 104456 records. I would like to copy the data to another table within that database. When I execute the command “insert into ChangeInsuranceTxnHistory select * from ChangeInsuranceTxn”, the following error occurs:
"Could not allocate space for object 'ChangeInsuranceTxnHistory' in database 'CC_CCAR' because the 'PRIMARY' filegroup is full."
My database settings are “automatically grow file” and I have checked “unrestricted file growth”. Could you assist me in fixing this?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!