[HELP] There is already an Object

[Zoas]

Hello, I wanted to use the Ariez preunlock script but having a problem with it.

CREATE Proc usp_Read_User_MaxGrow_R

@ServerID tinyint,
@UserUID int

AS

SET NOCOUNT ON

IF NOT EXISTS(SELECT GROW FROM CHARS WHERE ServerID=@ServerID AND UserUID=@UserUID AND GROW <= 3 )
BEGIN
UPDATE UserMaxGrow SET MaxGrow = 3 WHERE ServerID=@ServerID AND UserUID=@UserUID AND Country <= 1
END

IF EXISTS(SELECT GROW FROM CHARS WHERE ServerID=@ServerID AND UserUID=@UserUID AND GROW = 3 AND LEVEL >= 0)
BEGIN
UPDATE UserMaxGrow SET MaxGrow = 3 WHERE ServerID=@ServerID AND UserUID=@UserUID
END

IF EXISTS(SELECT GROW FROM CHARS WHERE ServerID=@ServerID AND UserUID=@UserUID AND GROW = 3 AND LEVEL >= 0)
BEGIN
UPDATE UserMaxGrow SET MaxGrow = 3 WHERE ServerID=@ServerID AND UserUID=@UserUID
END

SELECT Country,MaxGrow FROM UserMaxGrow WHERE ServerID=@ServerID AND UserUID=@UserUID

SET NOCOUNT OFF
GO

It says in the first line (CREATE Proc usp_Read_User_MaxGrow_R)
There is already an object called 'usp_Read_User_MaxGrow_R' int the Database.
I don't know what to do now.

[TeddyBear94]

u either deleate the existing one and run your script or you modify the existing one, which is the better way.

[Zoas]

Thanks to you, easy short answer and at last it worked.
And thanks generally for answering. You have a good know how and you share it with the community. You've got my respect for that.

[elfamosoo]

How can i delete the existing one ?

[nephren]

PS_GameDefs (or PS_GameData, im not sure) > Programability > Stored Procedure > usp_Read_User_MaxGrow_R
Rightclick > Delete.