I want query to Identify and report on any logins within Production databases that include "test" , "QA" , "UAT".
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
Not much to go on there I'm afraid.
Do you want a list of users inside the PROD database which contain the phrase TEST, QA, UAT?
SELECT name FROM sys.database_principals where name like '%test%' or name like '%QA%' or name like '%UAT%'
18 People are following this question.
how to get into SQL Server - Installation done through DPM tool. DO not have SA password.
My sql file content is nonesense
TCP/IP Port configuration on SQL server 2016
SQL Server User list extraction automation
Update Values of Related Records Located in Different Tables