Below is a simple script to get the database owner names.
SELECT name AS [Database Name], suser_sname( owner_sid ) AS [Database Owner Name] FROM sys.databases
Cheers!
No comments
-
Recent Posts
Archives
- December 2023
- November 2023
- September 2023
- August 2023
- July 2023
- June 2023
- March 2023
- December 2022
- November 2022
- October 2022
- September 2022
- July 2022
- March 2022
- November 2021
- October 2021
- August 2021
- June 2021
- May 2021
- February 2021
- January 2021
- December 2020
- November 2020
- July 2020
- April 2020
- December 2019
- November 2019
- September 2019
- July 2019
- June 2019
- March 2019
- February 2019
- January 2019
- November 2018
- October 2018
- August 2018
- July 2018
- June 2018
- March 2018
- February 2018
- January 2018
- October 2017
- August 2017
- July 2017
- June 2017
- May 2017
- April 2017
- March 2017
- November 2016
- October 2016
- September 2016
- August 2016
- July 2016
- June 2016
- May 2016
- April 2016
- March 2016
- February 2016
- January 2016
- November 2015
- October 2015
Categories
Tag Cloud
1118 AAG Backup backups cluster C programming crash recovery Database Disk Space Usage Error: 5042 he Transaction Log for Database is Full Due to Replication identify Current Running Queries Log Space Used Long running queries MySQL optimizer_switch Oracle Oracle MySQL Patching Pending Disk IO Performance Tuning Permissiosn PostgreSQL Projections RAC Real Application Clusters restore Ricky Valencia scheduler Service Broker Shell Scripting slow replication SQL Job SQL Server 2016 Installation SQL Server Agent srvctl strace tempdb tempdb contention Transaction Log Management Transaction log size Troubleshooting Troubleshooting. backupset Ubuntu Viewer State