June 6, 2006 at 5:04 am
Can anybody gives solution for the error shown below.
Error at Destination for Row number 1286902.Errors encountered so far in this task :1.
Could not allocate space for object ‘(SYSTEM table id: -515258363)’ in database ‘TEMPDB’ because the ‘DEFAULT’ filegroup is full.
I tried to import data into a table from a table in the other database.
Regards,
Biju.
June 6, 2006 at 6:59 am
Biju
It looks as if the data impiort process uses temp tables. You need to expand your tempdb so that it can accommodate all the necessary objects. Right-click on tempdb in Enterprise Manager, click on the Data Files tab, and increase the value of Space allocated.
John
June 6, 2006 at 9:39 pm
Thank you very much John
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply