Home Forums SQL Server 2008 SQL Server 2008 - General Changing db owner script RE: Changing db owner script

  • October 2, 2012 at 7:56 am

    #1544387

    i execute this against my central management servers:

    EXEC sys.sp_MSforeachdb '

    IF (SELECT owner_sid FROM sys.databases WHERE name = ''?'') <> 1

    ALTER AUTHORIZATION ON DATABASE::? TO [SA]

    '