I've run across a new and interesting issue with an external party's setup of SQLServer 7.
When I create a new user, give the user permissions to create objects, log on as that user using SQL Server authentication and create a table, the table is created as being owned by dbo and not my new user.
In any of my internal instances of SQLServer 7 or 2k, when an object is created, it is owned by the user who created it.
Can anyone offer me any suggestions on why the default ownership to dbo should be occuring, and what I can do to get around this without having to specify an authid before the object name at creation stage or running sp_change_object_owner afterwards?
It's not the end of the world if there's no way to avoid the above two options, but I'm interested to know why it's happening in the first place.