Copy and paste the code in the SQL Management Studio. It will generate the final script for you in the output screen. Copy them and run in the SQL Management Studio again and alter database owner details to SA.
SELECT 'use '+QUOTENAME(name)+ ' exec sp_changedbowner @loginame =''sa'' ' FROM sys.databases AS d WHERE d.database_id>4
2023-02-06 (first published: 2023-02-01)
833 reads
This week we have a few back to the basics security comments from Steve.
2019-06-25
389 reads
2019-04-09
1,391 reads
Sometimes you need to reach outside a database and access data and objects from multiple databases, which raises some security issues and increases the complexity of data access. In this stairway level, you’ll learn about cross-database ownership chaining so that you can reach across database boundaries securely.
2021-04-28 (first published: 2015-04-08)
9,356 reads
This script is to verify which login accounts have SID values that don’t match the correct SID values defined on the machine or in the domain.
2019-05-03 (first published: 2014-12-24)
1,603 reads
