Need help on this

[SimZero]

last night i got Gunz fully working but today as i try starting it up i get

MLocatorDBMgr::StartUpLocaterStauts - Could not find stored procedure 'spStartUpLocatorStatus'.

MLocator::Create - DBÃʱâÈ­ ½ÇÆÐ.

for Locator it never had this prob before

[MentaL]

[Phoenix]

Execute this on your database:

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spStartUpLocatorStatus]
 @LocatorID int
, @IP varchar(15)
, @Port int
, @UpdateElapsedTime int
AS
 SET NOCOUNT ON 
 IF EXISTS (SELECT LocatorID FROM LocatorStatus(NOLOCK) 
	    WHERE LocatorID = @LocatorID) BEGIN
  UPDATE LocatorStatus 
  SET IP = @IP, Port = @Port, UpdateElapsedTime = @UpdateElapsedTime, 
   LastUpdatedTime = GETDATE()
  WHERE LocatorID = @LocatorID
 END
 ELSE BEGIN
  INSERT INTO LocatorStatus(LocatorID, IP, Port, UpdateElapsedTime, LastUpdatedTime)
  VALUES (@LocatorID, @IP, @Port, @UpdateElapsedTime, GETDATE())
 END

[SimZero]

haah ya i saw your post on that longgg time ago but the thing is how i go about doing that lol beginner so so bear with me here lol

do i go to dbo.locatorstatus and edit that in?



Msg 2714, Level 16, State 3, Procedure spStartUpLocatorStatus, Line 16
There is already an object named 'spStartUpLocatorStatus' in the database.

paypaling 2$ to any who helps in this part LOL not jokeing