title: SQL Transport error timeout when creating an index
body: <p>I'm getting a transport error when I try to create an index. These are very large tables and I would expect the index to take a long time however I thought running the query from SSMS had no timeout and would run until completed.</p>
  
  <p>CREATE INDEX [IDX_Index1_field1_field2_field3] ON [Database1].[dbo].[Table1] ([field1], [field2], [field3]) INCLUDE ([Include1], [Include2], [Include3], [Include4], [Include5], [TypeId6], [Include7], [Include8], [Include9], [Include10], [Include11], [Include12])  </p>
  
  <p>The error is this: <a href="http://screencast.com/t/fyi1yyYg6" rel="nofollow">http://screencast.com/t/fyi1yyYg6</a></p>
  
  <p>Msg 10054, Level 20, State 0, Line 0
  A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)</p>
  
  <p>Is there anything I can do to prevent this Transport error from killing the index query? This is a SQL Azure DB btw.</p>
  
  <p>Thank for any help in advance.</p>