Contents tagged with logon
-
Logging SQL Server Logins
Source:
https://www.sqlservercentral.com/blogs/has-this-login-been-used-recently
--DROP TABLE #LogInfo
DECLARE @searchstring1 nvarchar(500) = ''
DECLARE @searchstring2 nvarchar(500) = '' … more
-
SQL Server Logon Trigger Examples
https://www.mssqltips.com/sqlservertip/6103/sql-server-logon-trigger-examples/ more
-
Office 365 Sign-in activity report error codes
https://docs.microsoft.com/en-us/azure/active-directory/reports-monitoring/reference-sign-ins-error-codes more
-
Audit Users logging in using "sa" or service accounts
source: https://www.sqlservercentral.com/scripts/audit-users-logging-in-using-sa-or-service-accountsIF OBJECT_ID ('AuditSqlLogins') IS NOT NULL DROP TABLE AuditSqlLogins
GO
CREATE TABLE … more