Jim Lawrence (AccessD)
accessd at shaw.ca
Tue Sep 14 11:40:38 CDT 2004
At the risk of over-stepping list etiquette. Me Too! Jim -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of John W. Colby Sent: Tuesday, September 14, 2004 6:55 AM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer] Quotes in delimited data >is that when reading a file and for some reason the application is improperly closed, the file that was being read is left locked but it is undamaged....just a cautionary note. This happens to me with SQL Server as well. If you have to use task manager to close EM, the database files end up locked but undamaged. Can't copy them to another drive (backup) but can use them at will. I understand that Windows has some utility that will clear those locks, which I'd dearly love to get my hands on. John W. Colby www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence (AccessD) Sent: Tuesday, September 14, 2004 8:39 AM To: dba-sqlserver at databaseadvisors.com Subject: RE: [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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com