Locator Problem

Joined
Feb 24, 2007
Messages
19
Reaction score
0
Location
Tampa,Florida
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'ServerStatus' in the database.
Msg 207, Level 16, State 1, Procedure spUpdateLocatorStatus, Line 0
Invalid column name 'RecvUDP'.
Msg 207, Level 16, State 1, Procedure spUpdateLocatorStatus, Line 0
Invalid column name 'SendUDP'.
Msg 207, Level 16, State 1, Procedure spUpdateLocatorStatus, Line 0
Invalid column name 'BlockUDP'.
Msg 207, Level 16, State 1, Procedure spUpdateLocatorStatus, Line 0
Invalid column name 'UpdateTime'.
Msg 207, Level 16, State 1, Procedure spStartUpLocatorStatus, Line 10
Invalid column name 'IP'.
Msg 207, Level 16, State 1, Procedure spStartUpLocatorStatus, Line 10
Invalid column name 'Port'.
Msg 207, Level 16, State 1, Procedure spStartUpLocatorStatus, Line 10
Invalid column name 'StatusTime'.

I tryed Making A New Prcedure and i got these errors Help
 
Here's the procedure for spStartUpLocatorStatus:

GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[spStartUpLocatorStatus]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'

CREATE PROCEDURE [dbo].[spStartUpLocatorStatus]
@SID int,
@SIP varchar(50),
@SPort nvarchar(50),
@SPlayer int
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO config (ServerID, IP, Port, MaxPlayer) VALUES (@SID, @SIP, @SPort, @SPlayer)
END

'
END
 
Upvote 0
Back