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