Db Owner

Question

Hi There,

I'm having a confusion regarding the data base owner. This may sound stup*** but i rather ask than not doing the right thing.

Who would be the best candidate for a db owner? (we are in a domain)

Local Admin / Domain Admin / SQL User?

Thanks

SD

---

Thanks for everything, all your help is well appreciated

Answer 1

Hello,

Because you can always change the database owner (see Changing the Database Owner) it doesn't really matter, which login you are using. If your SQL Server is already running in "Mixed Mode" you could create a dedicated SQL Login for using it as DBO.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

Hello,

Because you can always change the database owner (see Changing the Database Owner) it doesn't really matter, which login you are using. If your SQL Server is already running in "Mixed Mode" you could create a dedicated SQL Login for using it as DBO.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Hi Olaf,

Thanks for your time. That's all I really wanted to know.

Thanks again.

---

Thanks for everything, all your help is well appreciated