SQL SERVER 2000 object ownership.
Lets assume a user xyz has dbo rights on a database MyDB. He is not the default dbo, he only has dbo rights.
If user xyz creates a table in E.M the object owner will be dbo. but if the same user logon using query analyzer and create a table, the owner of the newly created table will be "xyz".
Why is that so? any tip?
Thank you.
zeeshan amin.