sql - Create Index On Azure Returns Error -

i have table on million rows in azure i'm trying add clustered index using following sql:

create clustered index ix_myidxname on [myapp].mytable([mycolumn]) (drop_existing=on) on [primary]

when through web interface runs on hour , fails error:

failed read status of response

if through sql management studio runs half hour , fails error:

40552: session has been terminated because of excessive transaction log  space usage. try modifying fewer rows in single transaction.

i it's saying, can it? want create clustered index, how can around transaction log size issue?

thanks

you try creating index with(online=on) option. should prevent long table locks...

My