Skip to content

SQL-Articles

On Premise and Cloud Database Knowledge Base

Tag: audit

Identify Orphan Users in All the databases

There are lot of scripts available in the internet to find orphan users across the database. This will be my version fo script to find out orphan users in all the databases excluding system databases.

Published October 19, 2015
Categorized as Scripts Tagged audit, orphan user, security

Retrieve Auditing Configuration Details

Script to retrieve auditing configuration details in sql server. Auditing feature is released from SQL Server 2008 onward so if you have utilized this feature then you can make use of this script to get quick information about audit configuration.

Published February 28, 2013
Categorized as Scripts Tagged audit, auditing, configuration, script, security

Recent Posts

  • CSSUG February 2020 Meet
  • CSSUG January 2020 Meet
  • CSSUG November 2019 Meet
  • CSSUG October 2019 Meet
  • Dropping a Subscriber from AG Publisher
SQL-Articles
Proudly powered by WordPress.