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’)