Were you running with elevated privledges? You'll need it to do some things in SQL Server.
>I have been learning SQL 2008. After creating a few related tables, I added a few additional column to one of the tables. When I attempt to save the table structure I get an error telling me that the table can not be dropped and re-created.
>
>1. Why when added a new column does SQL need to drop the original and re-create it?
>
>2. If the constraint are the problem, why doesn't SQL drop the constraints and recreate them?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer