BCP Problem - Please Help !

When I try to bcp out data from a table with text columns, the
following error prompted :
Starting copy...
SQLState = S1001, NativeError = 0
Error = [Microsoft][ODBC SQL Server Driver]Memory allocation failure
Most grateful if anyone can provide help on it. :?
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/Tools-BCP-Pr...ict245835.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=853003
terry_aibo <UseLinkToEmail@.dbForumz.com> wrote:
> When I try to bcp out data from a table with text columns, the
> following error prompted :
>
> Starting copy...
> SQLState = S1001, NativeError = 0
> Error = [Microsoft][ODBC SQL Server Driver]Memory allocation failure
>
> Most grateful if anyone can provide help on it. :?
You need more (virtual) memory - either on the client or server host. The
simplest you can do is to increase the paging file size of the machine with
mem problems.
Kind regards
robert