OBS: Esse código seu abaixo está errado.
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[Create_Characters] ON [dbo].[users] FOR INSERT
AS
INSERT INTO [dbo].[Characters](Login, CharType)
SELECT Login, 0 FROM [Inserted](nolock)
INSERT INTO [dbo].[Characters](Login, CharType)
SELECT Login, 1 FROM [Inserted](nolock)
INSERT INTO [dbo].[Characters](Login, CharType)
SELECT Login, 2 FROM [Inserted](nolock)
INSERT INTO [dbo].[Characters](Login, CharType)
SELECT Login, 3 FROM [Inserted](nolock)
INSERT INTO [dbo].[Characters](Login, CharType)
SELECT Login, 4 FROM [Inserted](nolock)
INSERT INTO [dbo].[Characters](Login, CharType)
SELECT Login, 5 FROM [Inserted](nolock)
Corrigido.
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
END
ALTER TRIGGER [dbo].[Create_Characters] ON [dbo].[users] FOR INSERT
ELSE
INSERT INTO [dbo].[Characters](Login, CharType)
SELECT Login, 0 FROM [Inserted](nolock)
INSERT INTO [dbo].[Characters](Login, CharType)
SELECT Login, 1 FROM [Inserted](nolock)
INSERT INTO [dbo].[Characters](Login, CharType)
SELECT Login, 2 FROM [Inserted](nolock)
INSERT INTO [dbo].[Characters](Login, CharType)
SELECT Login, 3 FROM [Inserted](nolock)
INSERT INTO [dbo].[Characters](Login, CharType)
SELECT Login, 4 FROM [Inserted](nolock)
INSERT INTO [dbo].[Characters](Login, CharType)
SELECT Login, 5 FROM [Inserted](nolock)
Váriaves lendo o GS&&GSCS Corretamente.