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?