• oh OK. There are advantages and disadvantages of both, the following link details rebuild vs drop and create

    http://msdn.microsoft.com/en-us/library/ms189858.aspx

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉