Hi

I have huge table - almost 150 GB, i want to add index and i run this:

CREATE NONCLUSTERED INDEX [IX_RateID]
ON [dbo].[Price] ([RateID]) WITH( ONLINE =  ON )

GO

BUT i get that:

Msg 40552, Level 20, State 2, Line 1
The session has been terminated because of excessive transaction log space usage. Try modifying fewer rows in a single transaction.

what can i do in order to run long  transactions?

pini