EXEC sp_insertRecord has too many arguments specified: Msg 8144, Level 16, State 2-Why I got this error?

hi all,

in object explorer of computername\sqlexpress, have database "shcdb" table "dbo.myfriends" has fields "personid" (int), "firstname", "lastname", "streetaddress", "city", "state", "zipcode", "e-mailaddress" set up.  when executed following query:

/////----shcsp-1.sql---////  

use shcdb

go

exec sp_insertrecord 3, "mary", "smith", "789 new st.", "chicago", "illinos", "12345", "m_smith@yahoo.com"

go

/////////////////////////////////////////////////////////////

i got following error message:

msg 8144, level 16, state 2, procure sp_insertrecord, line 0

procedure or function sp_insertrecord has many arguments specified.

(1) why did error?

(2) can documents explaining procedures 'sp_insertrecord', 'sp_delecterocord', 'sp_getrecord', 'sp_updaterecord', etc. , error messages?

please , give me answers above-mentioned questions.

 

thanks in advance,

scott chang

 

p. s.

i used pc @ home post above message.  have not been able post using my office pc in our lan system.  in my office lan system, i have been struggling figure out , solve the following strange thing:  log in http://forums.microsoft.com , "sign out" on time. if click on "sign out", "logout:  have been logged out of the forums." page time.  cause log me out?  how can resolved? our computer administrator? or microsoft? what department in microsoft can me solve problem? please advise on strange thing.  thanks.

 

 

in order give 'real' help, need code stored procedures.

 

try following:

 

execute sp_helptext sp_insertrecord

 

and post returned stored procedure code. may able you.

 

my suspicsion not need provide personid value insert.

but cannot without seeing code.

 

 

 

 

 

SQL Server  >  SQL Server Express