MSSQL --> webCreateAcc can't insert?

Hello people,

Can someone help me ?
Im using this script for my registerpage. ( See 2nd Script)
But when I want to inset it in my db Ill get the error:

PHP Code:

---

Msg 208, Level 16, State 6, Procedure webCreateAcc, Line 22
Invalid object name 'dbo.webCreateAcc'. 


---

Thx
Audioslave

PHP Code:

---

USE [ACCOUNT_DBF]
GO
/****** Object:  StoredProcedure [dbo].[webCreateAcc]    Script Date: 11/14/2010 13:35:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[webCreateAcc] 
    @account     VARCHAR(15),
    @password     VARCHAR(36),
    @email        VARCHAR(120)

AS

SET NOCOUNT  ON

DECLARE @DateActivated AS CHAR(8)

IF NOT EXISTS (SELECT account FROM ACCOUNT_TBL WHERE account = @account) BEGIN
    INSERT INTO ACCOUNT_TBL (account, [password], id_no1, id_no2, isuse, member, realname, cash) 
        VALUES (@account, @password, @password, @password, 'T', 'A', 'F', '0')

    SET @DateActivated =  CONVERT(CHAR(8), GETDATE()-1, 112 ) --Is the date today - 1
    --UPDATE ACCOUNT_TBL_DETAIL SET BlockTime = @DateYesterday WHERE account = @userid        
    --INSERT INTO ACCOUNT_TBL_DETAIL (account, gamecode, tester, m_chLoginAuthority, regdate, BlockTime, EndTime, WebTime, isuse)
    --    VALUES (@account, 'A000', '2', 'F', GETDATE(), '20990101', '20990101', '20050101', 'O')

    INSERT INTO ACCOUNT_TBL_DETAIL (account, gamecode, tester, m_chLoginAuthority, regdate, BlockTime, EndTime, WebTime, isuse, email)
        VALUES (@account, 'A000', '2', 'F', GETDATE(), @DateActivated, '20990101', '20050101', 'O', @email)

END
--ELSE BEGIN
--print '->Account exists = ' 
--print @account 
--END 


---

Please help me!!
#sorryfordoublepost

Look like the stored procedure "webCreateAcc" as never been created.So try changing

ALTER PROCEDURE [dbo].[webCreateAcc]

for

CREATE PROCEDURE [dbo].[webCreateAcc]


Cause at the moment, by "Altering", you are trying to edit a none-existant Stored procedure.


I'm not so sure about it tough, since the error is spotted on line 22.

Thanks men ! Your the best :)

Quote:

---

Originally Posted by Audioslave

Thanks men ! Your the best :)

---

Your welcome buddy !