存储过程改名后的问题

CREATE PROC [dbo].[listall]
@int_ID int = NULL,
@char20_LoginName varchar(20) = NULL,
@char12_Password varchar(12) = NULL,
@char20_F_Name varchar(20) = NULL,
@char5_M_Name varchar(5) = NULL,
@char20_L_Name varchar(20) = NULL,
@bit_Sex bit = NULL,
@tinyint_Favor_1 tinyint = NULL,
@tinyint_Favor_2 tinyint = NULL,
@tinyint_Favor_3 tinyint = NULL,
@bigint_Creditcard bigint = NULL,
@char30_eMail varchar(30) = NULL,
@char100_Address varchar(100) = NULL,
@int_Zip int = NULL,
@char20_Nation varchar(20) = NULL
AS INSERT CustomerList VALUES (@int_ID,@char20_LoginName,@char12_Password,@char20_F_Name,@char5_M_Name,@char20_L_Name,@bit_Sex,@tinyint_Favor_1,@tinyint_Favor_2,@tinyint_Favor_3,@bigint_Creditcard,@char30_eMail,@char100_Address,@int_Zip,@char20_Nation)
GO

各位，上面是我写的一个输入用户信息的存储过程，如果把as后面的东西去掉的话，就没有问题，但是加上的话，就会出现下面的错误。

Error 21037:[SQL-DMO] The name specified in the Text property's 'CREATE...' statement must match the Name property, and must be followed by valid TSQL statements.

我装的是sql2000中文版，请问有什么错误？谢谢。
---------------------------------------------------------------

你的存储过程改名了，但CREATE PROC [dbo].[listall] 中的名称还是原来的，将 [dbo].[listall] 改成新的名称就可以了。这是MS SQL Server的一个BUG，存储过程重命名，但存储过程中的文本的名称没有改过来。

--将newname 替换成你改名后的新名称。

CREATE PROC [dbo].[newname]
@int_ID int = NULL,
@char20_LoginName varchar(20) = NULL,
@char12_Password varchar(12) = NULL,
@char20_F_Name varchar(20) = NULL,
@char5_M_Name varchar(5) = NULL,
@char20_L_Name varchar(20) = NULL,
@bit_Sex bit = NULL,
@tinyint_Favor_1 tinyint = NULL,
@tinyint_Favor_2 tinyint = NULL,
@tinyint_Favor_3 tinyint = NULL,
@bigint_Creditcard bigint = NULL,
@char30_eMail varchar(30) = NULL,
@char100_Address varchar(100) = NULL,
@int_Zip int = NULL,
@char20_Nation varchar(20) = NULL
AS INSERT CustomerList VALUES (@int_ID,@char20_LoginName,@char12_Password,@char20_F_Name,@char5_M_Name,@char20_L_Name,@bit_Sex,@tinyint_Favor_1,@tinyint_Favor_2,@tinyint_Favor_3,@bigint_Creditcard,@char30_eMail,@char100_Address,@int_Zip,@char20_Nation)
GO