Skip to content

Instantly share code, notes, and snippets.

@Otterpohl

Otterpohl/Set-DatabaseOwnerToSA.sql

Created May 13, 2022 16:22
Show Gist options
  • Save Otterpohl/c42e51d63e35b940e350ad175ea37309 to your computer and use it in GitHub Desktop.
Save Otterpohl/c42e51d63e35b940e350ad175ea37309 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. Otterpohl created this gist May 13, 2022.
    5 changes: 5 additions & 0 deletions Set-DatabaseOwnerToSA.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,5 @@
    SELECT 'ALTER AUTHORIZATION ON DATABASE::' + QUOTENAME(d.[name]) + ' to sa'
    FROM [sys].[databases] d
    INNER JOIN [sys].[server_principals] s ON s.sid = d.owner_sid
    WHERE d.[name] NOT IN ('master','msdb','model','tempdb')
    AND s.[name] <> 'sa'