In SQL 2000 we did something that wasn't supported. We aliased manager accounts to dbo so that dbo would own all feature classes and tables. This no longer works in SQL 2008 since the sp_addalias procedure has been removed. So in 2008 we will need to use schemas.
The schema name must match the user name so I guess we will have to move all the dbo.featureclasses and dbo.tables to a new schema. Is there an easy way to do this?
Pure SQL allows a user to have a default schema different than their username. This allows a SQL user to create tables owned by dbo. Why doesn't ArcSDE support this?
