SQL Command error

• nhphuong76

  SSC Eights!

  Points: 986

  More actions

  July 26, 2012 at 8:52 pm

  #278556

  Hi SQL,

  I have issue when sql command

  content for bat file

  @ECHO OFF

  echo Executing the SQL Script...

  set fileName=D:\PurchaseItemExport\PurchaseItem_201207

  sqlcmd -Q "Exec DBName.dbo.StoreName" -o %fileName%.csv -h-1 -s"|" -W

  Result:

  Result file have data but end of file error

  Sqlcmd: Error: Internal error at GetDataRowset (Reason: Not enough storage is available to complete this operation).

  Sqlcmd: Error: Internal error at FormatRowset (Reason: Not enough storage is available to complete this operation).

  help me

  thanks,

  phuongnh

• HowardW

  One Orange Chip

  Points: 29109

  More actions

  July 27, 2012 at 3:22 am

  #1518358

  Is there enough disk space where the csv file is getting created? That would be the obvious cause of this error message...

• nhphuong76

  SSC Eights!

  Points: 986

  More actions

  July 27, 2012 at 3:43 am

  #1518370

  not enough disk space, because HDD more 10GB