Day: September 15, 2011

How to Find a Database User in Your SQL Environment

Sal Young | September 15th, 2011


PROBLEM: Sal Young is a member of your DBA team and today is his last day at work. You need to find out if his login is mapped to any database throughout your MS SQL environment. SOLUTION: I used Central Management Server, PowerShell, and SQLPSX. I queried my Central Management Server to get the name […]

Read More