I am facing a problem with bcp in. It would be a great help if you can provide some tips to solve it.
I am having a table created as :
create table TAB1 (id numeric(6,5) identity, data text);go;
when I execute bcp in to enter a file's contents in the text field, it gave an error saying "you are using a non-logged version of bcp".
if I created the table as :
create table TAB1 (id numeric(6,5) Primary Key, data text);go;
then the bcp executed fine and gave no error.
Please tell me how to do it with the former table.