This weekend, I tried to run some large bulk insert statements followed by create index statements on the tables I inserted the data into. For some reason, it didn't finish the largest insert statement. However, the index for that table started creating. Then my log file grew to a half a terabyte. Now the cancel statement is taking forever. What am I doing wrong Here is the part of the code.
..........
BULK
INSERT dbo.bigtable FROM 'data' WITH (TABLOCK);GO
USE [Database]GO
/****** Object: Index [ix_ID] Script Date: 04/27/2007 14:34:41 ******/
CREATE
CLUSTERED INDEX [ix_ID] ON [dbo].[bigtable](
[ID]
ASC)
WITH (PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PS_Year]([DatafileYear])GO