thanglequoc/ListOwner.sql

Created September 14, 2019 04:20

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/thanglequoc/dd2fe45d411efa6f636a44bce35546c7.js"></script>
Save thanglequoc/dd2fe45d411efa6f636a44bce35546c7 to your computer and use it in GitHub Desktop.

Download ZIP

Revisions

thanglequoc created this gist Sep 14, 2019.

ListOwner.sql

-Original file line number
+Diff line change
@@ -0,0 +1,10 @@
+    -- list database and owner id
+    SELECT SUSER_NAME(owner_sid), * FROM sys.databases;
+    -- view login creation date
+    SELECT *
+    FROM master.sys.sql_logins;
+    -- view database
+    SELECT *
+    FROM master.sys.databases;