Ich habe
--
-- Definition for stored procedure MAIL_STR_REALTIME :
--
GO
/****** Object: Stored Procedure dbo.MAIL_STR_REALTIME Script Date: 7/29/2008 3:34:04 AM ******/
create proc [dbo].MAIL_STR_REALTIME@iGu CHAR(2),
@serverindex CHAR(2),
@nMail_Before INT = 0,
@nMail_After INT = 0,
@idPlayer CHAR(7) = '0000000',
@nLevel INT = 0,
@iaccount VARCHAR(32) = '',
@tmCreate INT = 0,
@dwSerialNumber INT = 0,
@nHitPoint INT = 0
as
set nocount ondeclare @sdate datetime
declare @edate datetime
declare @iserverindex char(2)set @sdate = '18-07-2007 00:00:00'
set @edate = '31-08-2007 23:59:00'
set @iserverindex = cast((cast(@serverindex as int) + 50) as char(2))IF @iGu = 'S1'
BEGIN
SELECT * FROM MAIL_TBL
WHERE serverindex = @iserverindex AND byRead<90
ORDER BY nMail
RETURN
END
ELSE
IF @iGu = 'U1'
BEGIN
UPDATE MAIL_TBL SET nMail = @nMail_After, serverindex = @serverindex, dwSerialNumber = @dwSerialNumber, nHitPoint = @nHitPoint
WHERE serverindex = @iserverindex and nMail = @nMail_Before
RETURN
END
ELSE
IF @iGu = 'I1'
BEGIN
-- 추천 이벤트 기간인지 확인
IF(getdate() < @sdate or getdate() > @edate) BEGIN
RETURN
END
-- 추천인 인지 확인 -- select top 10 * from ACCOUNT_DBF.dbo.tblEventRecommend
-- IF( NOT EXISTS(SELECT * FROM ACCOUNT_DBF.dbo.tblEventRecommend where byaccount = @iaccount ) ) BEGIN
-- RETURN
-- END-- 받을수 있는 아이템이 있는지 확인
DECLARE @ItemID int
DECLARE @ItemNum int
DECLARE @bBinds int
SET @ItemID = 0
SET @ItemNum = 1
SET @bBinds = 2IF( @nLevel = 20 ) BEGIN
SET @ItemID = 26112
END
ELSE IF( @nLevel = 40 ) BEGIN
SET @ItemID = 26211
END
ELSE IF( @nLevel = 60 ) BEGIN
SET @ItemID = 26103
END
ELSE IF( @nLevel = 80 ) BEGIN
SET @ItemID = 30135
END
ELSE IF( @nLevel = 100 ) BEGIN
SET @ItemID = 5800
SET @bBinds = 0
END
ELSE IF( @nLevel = 120 ) BEGIN
SET @ItemID = 4703
SET @bBinds = 0
END
IF( @ItemID = 0 ) BEGIN
RETURN
END-- 메일 아이디 할당 하기
DECLARE @nMaxMailID int
SELECT @nMaxMailID = MAX(nMail)+1 from MAIL_TBL where serverindex = @iserverindex
SET @nMaxMailID = ISNULL( @nMaxMailID, 0 )-- 아이템 주기
DECLARE @szTitle VARCHAR(128)
DECLARE @szText VARCHAR(1024)
SET @szTitle = '레벨 업을 축하 드립니다!'
SET @szText = '캐릭터 레벨 업 기념 상품을 보내드립니다 ^ㅁ^* 프리프와 함께 즐거운 하루 보내시기 바랍니다. 감사합니다.'EXEC dbo.MAIL_STR 'A1', @nMaxMailID, @iserverindex, @idPlayer, '0000000', 0, @tmCreate, 0, @szTitle, @szText,@ItemID, @ItemNum, 0, 0, 0, 0, @bBinds
RETURN
END
GO
Diese Abfrage in jeder Datenbank probiert. In Account,Log, etc. Aber Fehler noch immer da.
CQuery LogFile:
2010/04/03 05:17:40
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Der Server 'RANKING' wurde in sys.servers nicht gefunden. Prüfen Sie, ob der richtige Servername angegeben wurde. Führen Sie bei Bedarf die gespeicherte Prozedur sp_addlinkedserver aus, um den Server zu sys.servers hinzuzufügen.
