- Joined
- Jan 11, 2010
- Messages
- 247
- Reaction score
- 45
The database is not complete for the server.
Lacks tables as well as stored procedures.
DB:QueensAccount
Procedure/View Missing object
usp_NAccountItemListbyAccount Tbl_DBErrors
usp_NAccountItemInsert Tbl_DBErrors
usp_NAccountItemDelete Tbl_DBErrors
usp_NAccountItemInsertByWeb Tbl_DBErrors
DataBase: QueensGame
Procedure/View Missing object
sp_upgraddiagrams dtproperties
usp_NCharNameChange GuildInfo
usp_NCastleUpdate tbl_Guild
usp_NFieldSpotUpdate tbl_Guild
usp_NRankBaselineDataUpdate tbl_Guild
usp_NRankBaselineDataUpdate tbl_GuildMember
usp_NArenaCharUpdate tbl_GuildMember
usp_NRankBaselineDataUpdateItem tbl_RankUpdateItemInfo
usp_NInsertSkill tbl_Skill_100310
And used external link server, example -> [usp_NRankBaselineDataUpdate] -> OPENQUERY -> FROM QB_MIDDLE_DB
Example:
Lacks tables as well as stored procedures.
DB:QueensAccount
Procedure/View Missing object
usp_NAccountItemListbyAccount Tbl_DBErrors
usp_NAccountItemInsert Tbl_DBErrors
usp_NAccountItemDelete Tbl_DBErrors
usp_NAccountItemInsertByWeb Tbl_DBErrors
DataBase: QueensGame
Procedure/View Missing object
sp_upgraddiagrams dtproperties
usp_NCharNameChange GuildInfo
usp_NCastleUpdate tbl_Guild
usp_NFieldSpotUpdate tbl_Guild
usp_NRankBaselineDataUpdate tbl_Guild
usp_NRankBaselineDataUpdate tbl_GuildMember
usp_NArenaCharUpdate tbl_GuildMember
usp_NRankBaselineDataUpdateItem tbl_RankUpdateItemInfo
usp_NInsertSkill tbl_Skill_100310
And used external link server, example -> [usp_NRankBaselineDataUpdate] -> OPENQUERY -> FROM QB_MIDDLE_DB
Example:
Code:
/****** Object: Table [dbo].[tbl_DBErrors] Script Date: 05.12.2021 15:54:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[tbl_DBErrors](
[Num] [bigint] IDENTITY(1,1) NOT NULL,
[ErrorNumber] [int] NULL,
[ErrorSeverity] [int] NULL,
[ErrorState] [int] NULL,
[ErrorProcedure] [nvarchar](126) NULL,
[ErrorLine] [int] NULL,
[ErrorMessage] [nvarchar](4000) NULL,
[RegDate] [datetime] NOT NULL,
CONSTRAINT [PK_tbl_DBErrors] PRIMARY KEY CLUSTERED
(
[Num] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty [USER=1333344765]name[/USER]=N'MS_Description', @value=N'순번' , [USER=501312]level[/USER]0type=N'SCHEMA' [USER=501312]level[/USER]0name=N'dbo', [USER=501312]level[/USER]1type=N'TABLE' [USER=501312]level[/USER]1name=N'tbl_DBErrors', [USER=501312]level[/USER]2type=N'COLUMN' [USER=501312]level[/USER]2name=N'Num'
GO
EXEC sys.sp_addextendedproperty [USER=1333344765]name[/USER]=N'MS_Description', @value=N'오류 번호' , [USER=501312]level[/USER]0type=N'SCHEMA' [USER=501312]level[/USER]0name=N'dbo', [USER=501312]level[/USER]1type=N'TABLE' [USER=501312]level[/USER]1name=N'tbl_DBErrors', [USER=501312]level[/USER]2type=N'COLUMN' [USER=501312]level[/USER]2name=N'ErrorNumber'
GO
EXEC sys.sp_addextendedproperty [USER=1333344765]name[/USER]=N'MS_Description', @value=N'오류 심각도' , [USER=501312]level[/USER]0type=N'SCHEMA' [USER=501312]level[/USER]0name=N'dbo', [USER=501312]level[/USER]1type=N'TABLE' [USER=501312]level[/USER]1name=N'tbl_DBErrors', [USER=501312]level[/USER]2type=N'COLUMN' [USER=501312]level[/USER]2name=N'ErrorSeverity'
GO
EXEC sys.sp_addextendedproperty [USER=1333344765]name[/USER]=N'MS_Description', @value=N'오류 상태 번호' , [USER=501312]level[/USER]0type=N'SCHEMA' [USER=501312]level[/USER]0name=N'dbo', [USER=501312]level[/USER]1type=N'TABLE' [USER=501312]level[/USER]1name=N'tbl_DBErrors', [USER=501312]level[/USER]2type=N'COLUMN' [USER=501312]level[/USER]2name=N'ErrorState'
GO
EXEC sys.sp_addextendedproperty [USER=1333344765]name[/USER]=N'MS_Description', @value=N'오류가 발생한 저장 프로시저 또는 트리거의 이름' , [USER=501312]level[/USER]0type=N'SCHEMA' [USER=501312]level[/USER]0name=N'dbo', [USER=501312]level[/USER]1type=N'TABLE' [USER=501312]level[/USER]1name=N'tbl_DBErrors', [USER=501312]level[/USER]2type=N'COLUMN' [USER=501312]level[/USER]2name=N'ErrorProcedure'
GO
EXEC sys.sp_addextendedproperty [USER=1333344765]name[/USER]=N'MS_Description', @value=N'오류를 발생시킨 루틴 내의 줄 번호' , [USER=501312]level[/USER]0type=N'SCHEMA' [USER=501312]level[/USER]0name=N'dbo', [USER=501312]level[/USER]1type=N'TABLE' [USER=501312]level[/USER]1name=N'tbl_DBErrors', [USER=501312]level[/USER]2type=N'COLUMN' [USER=501312]level[/USER]2name=N'ErrorLine'
GO
EXEC sys.sp_addextendedproperty [USER=1333344765]name[/USER]=N'MS_Description', @value=N'오류 메시지' , [USER=501312]level[/USER]0type=N'SCHEMA' [USER=501312]level[/USER]0name=N'dbo', [USER=501312]level[/USER]1type=N'TABLE' [USER=501312]level[/USER]1name=N'tbl_DBErrors', [USER=501312]level[/USER]2type=N'COLUMN' [USER=501312]level[/USER]2name=N'ErrorMessage'
GO
EXEC sys.sp_addextendedproperty [USER=1333344765]name[/USER]=N'MS_Description', @value=N'저장 시간' , [USER=501312]level[/USER]0type=N'SCHEMA' [USER=501312]level[/USER]0name=N'dbo', [USER=501312]level[/USER]1type=N'TABLE' [USER=501312]level[/USER]1name=N'tbl_DBErrors', [USER=501312]level[/USER]2type=N'COLUMN' [USER=501312]level[/USER]2name=N'RegDate'
GO
Last edited: