Identify and remove orphan sql accounts - TechRepublic
Question
March 15, 2009 at 03:08 AM
moizmd

Identify and remove orphan sql accounts

by moizmd . Updated 17 years, 4 months ago

Hi, we are using windows authentication and many contractors had access to our production database thru their domain account. though their domain accounts have been disabled/removed, I want to make sure that they don’t exist in SQL Server or in the database.

Is there a script that I can use to identify orphan accounts and delete them in SQL Server?

Thanks,
Moiz

This discussion is locked

All Comments