January 8, 2008 at 10:10 am
Hi all,
I need to change the production database owner while the applications attached to that database running.
I was wondering if it can break anything?
Thanks
January 8, 2008 at 10:53 am
I don't think so. Nothing has ever broken the dozen or so times I've run sp_changedbowner.
Greg
Greg
January 8, 2008 at 11:02 am
Thanks Greg,
I have changed the database owner and everything seems fine so far.
January 8, 2008 at 11:03 am
I hope the application is not using the present owner as its user when accessing the DB. Then it might break depending on the code I guess..
-Roy
January 8, 2008 at 12:28 pm
The application is using different sqlUserID and password, so it should be OK.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply