Tente assim:

Código:
USE [MUOnline]
GO

ALTER TABLE [dbo].[Character]
ALTER COLUMN [PkCount] [int] NOT NULL DEFAULT 0
GO

ALTER TABLE [dbo].[Character]
ADD [PkCountDay] [int] NOT NULL DEFAULT 0
GO

ALTER TABLE [dbo].[Character]
ADD [PkCountWeek] [int] NOT NULL DEFAULT 0
GO

ALTER TABLE [dbo].[Character]
ADD [PkCountMonth] [int] NOT NULL DEFAULT 0
GO

ALTER TABLE [dbo].[Character]
ADD [PkCountTotal] [int] NOT NULL DEFAULT 0
GO

ALTER TABLE [dbo].[Character]
ADD [HeroCount] [int] NOT NULL DEFAULT 0
GO

ALTER TABLE [dbo].[Character]
ADD [HeroCountDay] [int] NOT NULL DEFAULT 0
GO

ALTER TABLE [dbo].[Character]
ADD [HeroCountWeek] [int] NOT NULL DEFAULT 0
GO

ALTER TABLE [dbo].[Character]
ADD [HeroCountMonth] [int] NOT NULL DEFAULT 0
GO
Rode essa, depois rode a segunda, que é da trigger, separadamente.

Lembre-se de sempre fazer backup da DB antes de rodar qualquer query.

[]'s