[dba-SQLServer] Gigabit switch

John W. Colby jwcolby at colbyconsulting.com
Wed Sep 8 22:13:17 CDT 2004


The last file imported early this morning so the data is in!

Next question, do I need to leave logging off (it's set to bulk actually)
until I add the Identity PK?  How does logging work in a case like that?
Does SQL Server add a log entry for each record that it adds the value into?

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 John W.
Colby
Sent: Wednesday, September 08, 2004 12:51 AM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer] Gigabit switch


In fact I gave up on bcp because the data is surrounded by quotes.  DTS
strips them off but I can't for the life of me figure out how to have BCP do
that.  I'm almost done importing at this point.  The imports are (crossing
my fingers) proceeding smoothly, I am currently processing file 18 of 22,
thus by tomorrow morning I should have them all in.  

Then I have to figure out backup.  IMMEDIATELY!  I do NOT want to lose this
stuff and have to do it again.

John W. Colby
www.ColbyConsulting.com 





More information about the dba-SQLServer mailing list