CREATE PROCEDURE [dbo].[up_delete_character]
	@auth_id [uniqueidentifier],
	@character_id [uniqueidentifier]
as begin

set nocount on

	insert into CharacterTable_DELETE select * from CharacterTable with (READUNCOMMITTED) where character_id = @character_id
	delete from [dbo].[CharacterTable] WHERE character_id = @character_id

end