Home Forums SQL Server 7,2000 Administration DB Owner ''unknown'' on Model and MSDB databases RE: DB Owner ''''unknown'''' on Model and MSDB databases

  • March 18, 2005 at 12:09 pm

    #547864

    How about this code????
     
    Use Model
    go
    exec sp_configure 'allow', 1

    reconfigure with override

    go

    declare @sid varbinary(85)

    select @sid = sid from master.dbo.syslogins

    where loginname = 'sa'

    update master.dbo.sysdatabases

    set sid = @sid

    where dbid = db_id()

    exec sp_configure 'allow', 0

    reconfigure with override

     
    I successfully ran this against my MDSE Instance and was able to change the 'Owner' on the Model and MSDB databases to 'something other than sa' and then back again.    Any thoughts????????????????