-
ALTER LOGIN after Windows user or group name has been changed
If a Windows AD group or user has been renamed, and if that group or user was granted access to SQL Server in the past, then you can use ALTER LOGIN to rename the login inside of SQL Server: ALTER LOGIN [myDomain\oldName] WITH NAME = [myDomain\newName] It is not necessary to adjust user names in…