63,630 pts.
POSTED: Jun 18, 2008 8:22 PM (GMT)
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.
Finding the appropriate settings for copying tables within databases
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?
"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?
ASKED:
Jun 18, 2008 5:14 PM GMT
UPDATED:
June 18, 2008 8:22:18 PM GMT
RELATED QUESTIONS
- Office 2003 does not open/work
- database querying question SQLite
- Transcation Logs in Lotus Domino
- Changing Table with RUNSQLSTM
- Access 2007 Query Help
- Lotus Notes 8.5 Replicator error: Invalid or nonexistent document
- Create QA database with only some production tables
- Recovering lost data from SQL Server 2005
- Stream Files (STMF)
- decimal change on my paradox database
Answer Wiki:
Either your hard drive is full, or your hard drive is to slow to increase the data files within the timeout period.
Try reducing the size of the growth to a specific number (if in %) of like 256 Megs.
Try reducing the size of the growth to a specific number (if in %) of like 256 Megs.
To see other answers submitted to the Answer Wiki View Answer History.
