Receiving Column name or number of supplied values does not match table definition... - Backup, Recovery and Disaster Recovery

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » SQL Server Database Administration » Backup, Recovery and Disaster Recovery » Receiving Column name or number of supplied values does not match table definition...

Receiving Column name or number of supplied values does not match table definition...

Options

Previous Topic · Next Topic

dbist

Posted: Thursday, June 21, 2007 10:24:42 AM

Rank: Newbie

Joined: 6/21/2007
Posts: 0
Points: 9
Location: Brooklyn, NY

I'm a noob, using MS SQL 2005. Trying to use a stored procedure I got from SQL 2000 DB integrity to work with 2005. Receiving:

Message
Executed as user: MMCRSDOM\teletracksql. Insert Error: Column name or number of supplied values does not match table definition. [SQLSTATE 21S01] (Error 213) RESTORE FILELIST is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.

Please help.

Scott Whigham

Posted: Thursday, June 21, 2007 10:44:48 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

Too little info. That's like calling up a car repair shop and telling the repair person who answers the phone, "My car makes this whir, whir, whir sound - what do I need to do to fix it?" They would just laugh and say, "I don't know. Bring it in."

Show us the source code of the proc and perhaps we can help otherwise no dice...

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.