Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-24 : 01:22:49
|
| Edward writes "We have recently migrated our databases from SQL 7.0 to SQL Server 2000. After the migration, our databases were working fine. Then a week later, we began receiving this error when we attempted to add new records:Error Type:Provider (0x8007000E)Not enough storage is available to complete this operation.We realized that this error only occurred with tables that had a field in it that was designated as 'ntext'. We do not think it was an error that occurred due to the migration, because the error did not occur until a week later. We noticed the error the Monday after I deleted records out of our databases on Friday.Thank you for help in answering this dilemma.Edward Cox" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-06-26 : 00:38:34
|
| Edward, I know this sounds stupid, but have you tried rebooting?If you have, and you still get the problem answer the following:How are you trying to insert the rows? QA? Textcopy? Bulk Insert? Something else?-Chad |
 |
|
|
|
|
|
SQL Server 2000: error with ntext