Procédure stockée qui fait ça :
/DNNDNN Object: StoredProcedure {databaseOwner}[{objectQualifier}ChangeUserName] Script Date: 12/12/2006 18:36:09 DNNDNN/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE {databaseOwner}[{objectQualifier}ChangeUserName]
@oldName nvarchar(128),
@newName nvarchar(128)
AS
DECLARE @error_var int, @rowcount_var int, @newNameCount int
begin transaction
select @newNameCount = count(*)
from {objectQualifier}Users
where Username = @newName
if @newNameCount > 0
begin
select 1 /* NewUsername already Exists */
ROLLBACK TRANSACTION
RETURN
end
update {objectQualifier}Users
set Username = @newName
where Username = @oldName
SELECT @error_var = @@ERROR, @rowcount_var = @@ROWCOUNT
IF @rowcount_var <> 1 OR @error_var <> 0
BEGIN
select 2 /* {objectQualifier}User could not update */
ROLLBACK TRANSACTION
RETURN
END
update aspnet_Users
set
Username = @newName,
LoweredUserName = LOWER(@newName)
where LoweredUserName = LOWER(@oldName)
SELECT @error_var = @@ERROR, @rowcount_var = @@ROWCOUNT
IF @rowcount_var <> 1 OR @error_var <> 0
BEGIN
select 3 /* aspnet_User could not update */
ROLLBACK TRANSACTION
RETURN
END
Commit transaction
select 0 /* Operation successfully terminated */
Manuellement :
- Sauvegarde la base de données,
- Ouvre la table Users, change ton pseudo,
- Ouvre la table aspnet_Users, change les deux entrées pour ton user (UserName et LoweredUserName).
Pense également que lors de l'installation le mode Avancé te permet de choisir tes pseudos (entre autres).
seb