Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select [name] as [dbname],
- SUSER_SNAME([owner_sid]) AS [currentowner],
- N'ALTER AUTHORIZATION ON DATABASE::'
- + QUOTENAME([name]) + ' TO '
- + QUOTENAME((SELECT [name] FROM sys.sql_logins WHERE sid = 0x01)) AS scriptoutput
- from sys.databases
- where database_id > 4
- AND owner_sid <> 0x01
- AND state_desc = 'ONLINE'
Advertisement
Add Comment
Please, Sign In to add comment