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 »
user
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