Re: changedbowner of msdb and model to 'sa'

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Maggie (Maggie_at_discussions.microsoft.com)
Date: 01/12/05 

Date: Tue, 11 Jan 2005 22:49:06 -0800

Is there any other method that I can change the own to sa for msdb and model?
 For instance, register as 'sa' then detach/attach msdb and model?

"Jasper Smith" wrote:

> You can't. The code for sp_changedbowner contains the check
>
> if db_name() in ('master', 'model', 'tempdb')
> begin
> raiserror(15109,-1,-1)
> return(1)
> end
>
> The error message just referring to master even though you're in model is a
> bug that looks like it's fixed in SQL2005. The error returned in SQL2005 is
> a bit clearer
>
> Server: Msg 15109, Level 16, State 1, Line 1
> Cannot change the owner of the master, model, tempdb or distribution
> database.
>
> --
> HTH
>
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Maggie" <Maggie@discussions.microsoft.com> wrote in message
> news:A899869B-F12F-4070-ACBD-693CF53DF74F@microsoft.com...
> > We are trying to exec sp_changedbowner 'sa' on model database from the
> > service account 'service_sql' to 'sa'.
> > However, we got the follow error:
> > 15109 16 Cannot change the owner of the master database.
> >
>
>
>