T-SQL Tuesday 138 – sp_help_revlogin is dead, long live sp_help_revlogin2
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?
Home »
login
Finding the Details Missing from the SQL Server Failed Logins Audit
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!
Read More »Finding the Details Missing from the SQL Server Failed Logins Audit
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.
Read More »T-SQL Script to Fix Orphaned DB Users Easily