>>I check and all of you are correct. The data is preserved after the re-creation. Funny, none of the documentation I found attempt to clarify that point. The statement on the checkbox led me to beleive it would not preserve the data.
>>
>The option may be a bit confusing, but from the common sense, why would SQL Server dump data? This will be considered a major bug then.
M$ does alot of strange changes from one version to the next. It reminds me a statement I once heard...
We have made these unnecessary changes for Your inconvenience.
Greg Reichert