How To Change All Database owners to SA



How To Change All Database owners to SA

How To Change All Database owners to SA

QUERY:
SELECT NAME,SUSER_SNAME(OWNER_SID) AS OWNER FROM SYS.DATABASES WHERE SUSER_SNAME(OWNER_SID) != (‘SA’)

–========================

SELECT NAME,OWNER FROM
(SELECT NAME,SUSER_SNAME(OWNER_SID) AS OWNER FROM SYS.DATABASES) TEMP
WHERE OWNER NOT IN (‘SA’)

SELECT ‘ALTER AUTHORIZATION ON DATABASE::’ + ‘ ‘+ NAME+ ‘ ‘+ ‘TO SA’ FROM SYS.DATABASES WHERE SUSER_SNAME(OWNER_SID) != (‘SA’)