Locator Problem

[ElementalShadow]

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

[MentaL]

[razorblitz07]

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

[Linear88]

Create a new Database, Call It iGunzDB then do everything you need. Delete the old Procedure for dbo.ServerStatus. Remove all USE [GunzDB] statements. After that settle with your other modifications and then execute it. Rename GunzDB to OldGunzDB and iGunzDB to GunzDB.