spInsertChar problems

Newbie Spellweaver
Joined
Jul 11, 2006
Messages
13
Reaction score
0
Location
Hell
Ok, I'm trying to fix the black lobby problem, and I paste this in over what I have in spInsertChar

Code:
CREATE PROCEDURE [dbo].[spInsertChar]
	@nAID INT,
	@nCharIndex INT,
	@szName nvarchar(32),
	@nSex INT,
	@nHair INT,
	@nFace INT,
	@nCostume INT
AS
BEGIN
	SET NOCOUNT ON;

	DECLARE @cnt INT
	SELECT @cnt=COUNT(*) FROM Character WHERE AID = @nAID
	
	DECLARE @cid INT
	SELECT @cid=COUNT(*) FROM Character

	INSERT INTO Character VALUES(@nAID,@szName,@cnt,1,@nSex,@nCostume,@nFace,@nHair,NULL,0,10000,0,0,0,0,0,0,0,0,0,0,0,0,@cnt,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,NULL)
END
GO

But then I hit Execute and get this message

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

Any clue what the hell is going on? I believe this is the only thing making my server unplayable.

Also, I didn't post this in the Q&A section because the newest page won't load for me, so I wouldn't be able to get an answer.

Edit: If no one's gonna take some time to help a guy out, just lock this thing.
 
Back