Hello,

We are running SQL Server 2005 enterprise with SP2.  Recently, after
assigning db_ddladmin permissions to someone, I ran across something that I'm
curious about.  It seems that as a db_ddladmin of a database in the dbo
schema, it's possible to create and drop objects, but not alter them using
Management Studio.  However, it is possible to alter objects in Query Editor
as db_ddladmin.  This isn't really a problem as we can use TSQL for these
modifications.  Just curious as to what appears to be a difference in
behavior between Management Studio and Query Editor.  

I'm new to SQL Server 2005's security model, but from the messages returned
when attempting to modify with the GUI, my guess is that this has something
to do with the differences in SQL Server 2000 and 2005 regarding users and
schemas owning objects.  But I'm not sure why the behavior appears
inconsistent between the GUi and TSQL.  Is the behavior different or am I
missing something?

Thanks,
Greg