ironhide1975
Programmer
Greetings all, any help on this problem would be appreciated.
Recently while attempting to export a Production Database to Development I noticed that the varchar comments field were not copying the data over. The varchar was sent to 8000 (the highest it can go). When we reduced this to a lower number (450) copying went fine. I'm not sure the reason we decided to keep it a varchar and not a text field. Text fields seems to copy over fine, and we are using SQL 7.
Is there a bug somewhere in 7 that won't copy the varchar over? My main concern that this problem might creep up somewhere else long after the data is gone.
Also does anyone know how you can tell what version of SQL you have on your machine? Any help is appreciated.
Recently while attempting to export a Production Database to Development I noticed that the varchar comments field were not copying the data over. The varchar was sent to 8000 (the highest it can go). When we reduced this to a lower number (450) copying went fine. I'm not sure the reason we decided to keep it a varchar and not a text field. Text fields seems to copy over fine, and we are using SQL 7.
Is there a bug somewhere in 7 that won't copy the varchar over? My main concern that this problem might creep up somewhere else long after the data is gone.
Also does anyone know how you can tell what version of SQL you have on your machine? Any help is appreciated.