Change User's Domain for Windows Authenticated Users

To change user's domain for windows authenticated users you have to run the provided sql script:

USE [TeamPulse]
    GO

    DECLARE @Domain nvarchar(128) = 'PROGRESS' /* CHANGE THIS to the DOMAIN that the new user will use*/
    DECLARE @OldDomain nvarchar(128) = 'TELERIK' /* Old domain that user was using */
    DECLARE @UserID int = 42 /* CHANGE THIS to the UserID (from the User table) of the user that is being converted */
    DECLARE @AspnetUserID uniqueidentifier
    DECLARE @Username nvarchar(256)

    /* Get the current user's information */
    SELECT
     @AspnetUserID = u.StsUserID,
     @Username = u.Username
    FROM [TeamPulse].[dbo].[User] u
    WHERE u.UserID = @UserID

    /* Modify user in User table */
    UPDATE [User]
    SET Domain = @Domain,
        Provider = 'Windows'
    WHERE UserID = @UserID


    /* Modify user in aspnet_Users table */
    UPDATE [aspnet_Users]
    SET UserName = @Username + '@' + @Domain,
        LoweredUserName = LOWER(@Username + '@' + @Domain)
    WHERE UserName = LOWER(@Username + '@' + @OLdDomain)