CHARACTER_01_DBF.dbo.LoadSiegeRanking Help

[randeljohnvalencia]

how to fix this ?

 Spoiler

2016/10/20 07:49:42
query:{ call CHARACTER_01_DBF.dbo.LoadSiegeRanking('01') }
SQLSTATE:42000 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'CHARACTER_01_DBF.dbo.LoadSiegeRanking'.

[xkilyx]

Could not find stored procedure "CHARACTER_01_DBF.dbo.LoadSiegeRanking"

Execute this

 Spoiler

USE [CHARACTER_01_DBF]
GO
/****** Object: StoredProcedure [dbo].[LoadSiegeRanking] Script Date: 04/26/2016 19:16:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE proc [dbo].[LoadSiegeRanking]
@dex char(2)
as
set nocount on
set xact_abort on

select szName, idPlayer, nJob, nKills, nDeaths, nPoints
from PlayerWar_TBL
where serverindex = @dex
return

and this

 Spoiler

USE [CHARACTER_01_DBF]
GO

/****** Object: Table [dbo].[PlayerWar_TBL] Script Date: 04/26/2016 19:18:08 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[PlayerWar_TBL](
[serverindex] [char](2) NULL,
[szName] [varchar](32) NULL,
[idPlayer] [char](7) NULL,
[nJob] [int] NULL,
[nKills] [int] NULL,
[nDeaths] [int] NULL,
[nPoints] [int] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO