I am using the column sqltextinfo in dbc.qrylogsql table and its giving .txt files. Can i get plain text in the table itself.
As far as I know, no. However, I think you cna do this way:
Thanks for the quick response... If i am joining with dbc.qrylog its getting plain txt but if i joined with dbc.qrylogtbl i am getting .txt files.
I am not sure of plain text and .txt .Maybe your settings in SQL Assistant. Can you cast it to a varchar 64000 maybe and see if it works.