Soacs Ebenzer Açılmıyor hata veriyorsa fixle

 

1299 soacs server files ebenzeriniz açiiyorsa aşağıdaki kodla fixleyin.

Genelde bunun sebebi databasenizde grafe ve sembol sistemiz eksik olmasindan yani 100 user yokken grade sembol sifirlarsankz birde ustune db sifirlayip denerseniz tablolar boşaldı için ebenzer açılmaz hata verir.

Başka hataniz varsa yorumla bildiriniz.

Fiz kodu.

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[USER_KNIGHTS_RANK]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[USER_KNIGHTS_RANK]
GO

CREATE TABLE [dbo].[USER_KNIGHTS_RANK] (
    [shIndex] [smallint] NOT NULL ,
    [strName] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
    [strElmoUserID] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [strElmoKnightsName] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [nElmoLoyalty] [int] NULL ,
    [strKarusUserID] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [strKarusKnightsName] [char] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [nKarusLoyalty] [int] NULL ,
    [nMoney] [int] NOT NULL 
) ON [PRIMARY]
GO

INSERT INTO USER_KNIGHTS_RANK VALUES ( 1, 'Gold', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 2, 'Silver', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 3, 'Silver', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 4, 'Silver', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 5, 'Mirage', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 6, 'Mirage', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 7, 'Mirage', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 8, 'Mirage', null, null, 0, null, null, 0, 0);
[only the first 25 lines shown in this example]