login

T-SQL Tuesday 138 – sp_help_revlogin is dead, long live sp_help_revlogin2

2021-05-11
SQL Server Database Development, Tools and Scripts
3 Comments

This month’s #tsql2sday is hosted by @AndyLeonard, who asks us to write about “software changes”. Well, I think it’s time to be changing sp_help_revlogin. What do you think?

Finding the Details Missing from the SQL Server Failed Logins Audit

2020-03-09
T-SQL, Tools and Scripts

We all know the error log used by SQL Server to audit failed logins by default. But is it good enough? For many scenarios, it isn’t. It’s actually missing a lot of important information. But, worry not, for there are better solutions!

T-SQL Script to Fix Orphaned DB Users Easily

What are Orphaned Users

“Orphaned Users” is a common issue in SQL Server where a Database User is no longer associated with its relevant Server Login.

This often happens when the Server Login is deleted (even if it’s recreated later), or when the database is moved or restored to a different SQL Server.