Can you set DBO as default object owner?

[Michael Frank]

Although I am in the DBO role, whenever I create an object I am put in as the object owner. For the way our database is set up, all of our objects are owned by DBO, and it can be a pain to have to remember to set the owner when creating an object. In 6.5, if you were aliased as dbo, all objects you created were owned by dbo. This is the functionality I'm looking for.

Is there any way to have dbo be the default owner of an object when it is created? Again, I am in the dbo role.

[Ray Miao]

Use dbo.object_name to create any object in db.


------------
Michael Frank at 10/13/99 11:23:56 AM


Although I am in the DBO role, whenever I create an object I am put in as the object owner. For the way our database is set up, all of our objects are owned by DBO, and it can be a pain to have to remember to set the owner when creating an object. In 6.5, if you were aliased as dbo, all objects you created were owned by dbo. This is the functionality I'm looking for.

Is there any way to have dbo be the default owner of an object when it is created? Again, I am in the dbo role.