I need to form a query that lists all the databases that include the words 'PRD' that have a single specific user name 'user_1'
So far I have this query:
select name as username, create_date, modify_date, type_desc as type, authentication_type_desc as authentication_type from sys.database_principals where type not in ('A', 'G', 'R', 'X') and sid is not null and name != 'guest' and name = 'user_1' order by username;
The above query will require me to do "use database name" for each database. How can I include all the databases that contain the word 'PRD' in it?
Any help is appreciated.
EDIT: How can I combine the above query with the query below?:
SELECT name FROM master.sys.databases where name like '%PRD%'