Determine Login Usage

  • How can I determine how logins are used and identify those that are not being used? We restored some test databases on a development server and now have a bunch of mysterious logins that I would like to delete.

  • You can run profiler to capture usage, analyze, etc. PIA if you ask me. The best and easiest way is to deny login for those you're not sure about and see what breaks or who calls. Then enable them selectively as needed, a few months after that, delete them. I'd use sp_help_revlogin from MS to script them out first in case you need to bring them back. Also script out their roles/permissions.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply