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)
873 reads
This week we have a few back to the basics security comments from Steve.
2019-06-25
411 reads
2019-04-09
1,400 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.
2024-05-08 (first published: 2015-04-08)
11,021 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,618 reads
