Right now, we have 2 SQL 2008 Standard instances, and I am noticing something that is causing me a little concern.
Every time that I have a made a change to a table schema, I have had to drop and re-create the table. It doesn't matter if the table has data in it or not.
In 2005 Standard, I rarely have to drop and re-create the table for column modifications.
I am a system administrator on the SQL boxes.