[Duster]

By default who is the ownership of the schema in Bes 4.1: i change it to a owner but i want to put it back to the default and i dont know who was the default owner was.

[x14]

It's the account that was used to create the db.

[Duster]

i used my admin account to create the database but its not there to select from. so who should i put as the owner?

[x14]

Change it to sa.

[Duster]

Originally Posted by x14

Change it to sa.

sa didnt show up im using 2005 i changed it to dbo is that good ?I have the dbo owner as an active dir admin account.dbo account owns all of the schema on the sql 2005 server. If my admin account password expires or gets locked in active directory will that cause sql database problems.