July 30, 2008 at 9:15 am
I'm looking for a little advise, we had a dba leave the company and she created multiple db's and sql jobs under her windows account. I've read so many different ways of changing the dbo that I would like to get a best practice on this.
Should I change the dbo to sa or another windows account?
If I change the sa password what will this effect?
Thanks
We have SQL 2000 and 2005
July 30, 2008 at 11:34 am
The best thing to do is set up a service account that you use for that kind of thing.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 30, 2008 at 8:41 pm
Changing sa or windows account password has no impact on DB/job ownership.
It does not matter the DB is under sa or windows account. You may have to change the password whenever there is a need.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply