1. Home
2. Questions
3. AI Assist Labs
4. Tags
6. Challenges
7. Chat
8. Articles
9. Users
11. Jobs
12. Companies
13. Collectives
14. Communities for your favorite technologies. Explore all Collectives
Teams

Ask questions, find answers and collaborate at work with Stack Overflow for Teams.
Try Teams for free Explore Teams
Teams
Ask questions, find answers and collaborate at work with Stack Overflow for Teams. Explore Teams

Return to Answer

Improve formatting.

Source Link

edited Dec 9, 2015 at 12:34

SELECT * FROM sys.databases db WHERE db.state = 0 and owner_sid <> 0x01

SELECT *
FROM sys.databases db WHERE
db.state = 0 and owner_sid <> 0x01

You can skip system databases, list only user databases

SELECT * FROM sys.databases db WHERE db.state = 0 and owner_sid <> 0x01

You can skip system databases, list only user databases

SELECT *
FROM sys.databases db WHERE
db.state = 0 and owner_sid <> 0x01

You can skip system databases, list only user databases

Source Link

answered Dec 9, 2015 at 9:50

SELECT * FROM sys.databases db WHERE db.state = 0 and owner_sid <> 0x01

You can skip system databases, list only user databases