[dba-SQLServer] Quotes in delimited data

Hi Stuart:

Try 'NoteTab' or 'CrimsonEditor' against any file the exceed 2GB and
'NoteTab' will choke and I suspect 'CrimsonEditor' will as well. ...the old
famous 2GB limit rears it's ugly head... :-(

The class I just sent, I used a couple of years ago to read large files. I
just tested it on a 70GB file and it had no problems. One issue that I have
found, is that when reading a file and for some reason the application is
impropertly closed, the file that was being read is left locked but it is
undamaged....just a cautionary note.

Jim

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Stuart
McLachlan
Sent: Monday, September 13, 2004 11:25 PM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer] Quotes in delimited data


On 13 Sep 2004 at 21:56, Jim Lawrence (AccessD) wrote:


> This is part of the reply that I got from 'Notetab' a while when I was
doing
> some research. Did not get as far as 'CrimsonEditor'.
>
> <comment from support>
> Theoretically, NoteTab can open 2GB files; it depends on system
> resources.
----8<-----
>
> In John's case it may not be enough.

I should hope it is, we were only talking about editing the 660 lines in
the BCP format file, not doing a find a replace on the data files.  :-)





--
Stuart


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com