Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-05-30 : 08:49:59
|
| zubair writes "Hello I had a database locally it worked just fine, but the problem cripled when I uploaded my site and datbase to remote SQL Server.I copied whole the database through SQL Scripts and then transferred the data trough DTS,Its unable to create one of my stored procedures.I'm getting this error://---------Server: Msg 213, Level 16, State 4, Procedure PIU_User_Provider, Line 30Insert Error: Column name or number of supplied values does not match table definition.//----------------------Please if anyone can help me in figuring out the problem, and suggesting a solution. I wud be greatful.The structure of the database tables is same on local and remote since I have created the database through scripts and DTS.thnx in anticipation.zubair" |
|
|
vijayakumar_svk
Yak Posting Veteran
50 Posts |
Posted - 2005-05-30 : 10:41:50
|
| Can you update the table script and stored procedure script?Work smarter not harder take control of your life be a super achiever |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-05-30 : 10:46:55
|
| Please supply the offending code....and DDL of the table being inserted into.Can you PROVE your tables (test+prod) are in sync....by using something like red-gate.com?? |
|
|
|
|
|
|
Column name or number of supplied values doesn't exist