Change User's Domain, Username And Email for Windows Authenticated Users
To change user's domain, username and email for windows authenticated users you have to run the provided sql script:
USE [TeamPulse]
GO
DECLARE @oldUsername NVARCHAR(100) = 'kivanov1'
DECLARE @userId int = (SELECT u.UserId from [dbo].[User] u where u.Username = @oldUsername)
DECLARE @newDomain NVARCHAR(100) = 'TELERIK'
DECLARE @newUsername NVARCHAR(100) = 'kivanov'
DECLARE @newEmail NVARCHAR(100) = 'kamen.ivanov@telerik.com'
DECLARE @StsUserId nvarchar(40) = (select u.StsUserID from [dbo].[User] u where u.UserID = @userId)
UPDATE
[dbo].[User]
SET
Domain = @newDomain,
Username = @newUsername,
Email = @newEmail
WHERE
UserID = @userId
UPDATE
[dbo].[aspnet_Membership]
SET
Email = @newEmail,
LoweredEmail = LOWER(@newEmail)
WHERE
UserId = @StsUserId
UPDATE
[dbo].[aspnet_Users]
SET
UserName = @newUsername + '@' + @newDomain,
LoweredUserName = LOWER(@newUsername + '@' + @newDomain)
WHERE
UserId = @StsUserId