Openquery gives me a system.OutOfMemory Error

• arifrefai

  Grasshopper

  Points: 13

  More actions

  February 13, 2008 at 3:22 am

  #98791

  Hi All,

  i am writing a simple openquery to pull data from a very large table and the query failed with error saying system.OutOfMemory Error. i notice that i m able to pull all the column except columns with datetime data type. i am able to retrieve data if i suppress the timestamp for the particular column, but i need to retrieve data with timestamp. Please help me out. Thanks in Advance.

  Arif

• tbeadle

  SSCommitted

  Points: 1635

  More actions

  February 14, 2008 at 1:31 pm

  #778572

  [font="Arial"]

  Hello

  Is is possible to convert the date into date part and time part in two varchar defined columns and then output the two columns that way?

  Regards,

  Terry

  [/font]