Query to rebuild index fails

These command fails:

     alter index [PrimaryKey_8c6d0863-216f-4228-bedd-86bd2b4df8e3] ON dbo.Picture REBUILD

     alter index IX_Picture_0 ON dbo.Picture REBUILD

When I execute the command remotely I get the error message: "Query timeout expired."

When I execute the command from the Azure web site query window I get the message "Failed to read the status of the response".

The "Picture" table is 5.01 GB with 3,473 records

The table has 4 fields:

     ID - int - primary key

     ItemID - int

     PictureName nvarchar(50)

     Picture - image

and the 2 indexes listed in the failed commands, one index is on ID and the other is on ItemID

September 26th, 2013 9:19am

I would say execute query from SSMS and make sure query timeout is set to 0.

Free Windows Admin Tool Kit Click here and download it now
September 29th, 2013 2:10pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics