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.
mapping the keyword(UserRole) in entity framework
BATCH file hangs when executes through SQL Job
Call a stored procedure with parameters in a user defined function in SQL SERVER
Loop Day Wise SQL to Insert Data
how can i use case statement with having clause