DNN – Rename Admin User

SET NOCOUNT ON

DECLARE @OldUsername nvarchar(100),
   @NewUsername nvarchar(100)

SET @OldUsername = 'dkittell1'
SET @NewUsername = 'dkittell'

UPDATE dnn_Users SET [Username] = @NewUsername WHERE [Username] = @OldUsername;
UPDATE aspnet_Users SET [LoweredUserName] = @NewUsername WHERE [LoweredUserName] = @OldUsername;
UPDATE aspnet_Users SET [UserName] = @NewUsername WHERE [UserName] = @OldUsername;
UPDATE dnn_EventLog SET [LogUserName] = @NewUsername WHERE [LogUserName] = @OldUsername;