home
training courses
why choose us?
solutions
support
company
LearnItFirst User Forum
Welcome Guest
Search
|
New Posts
|
Members
|
Log In
|
Register
SQL Server Forum - LearnItFirst.com
»
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
Where do you live?: 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.
Back to top
Scott Whigham
Posted:
Thursday, June 21, 2007 10:44:48 AM
Rank: Super Mod
Joined: 3/20/2006
Posts: 460
Points: 1,002
Where do you live?: 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...
Back to top
Users browsing this topic
Guest
Forum Jump
SQL Server Database Administration
- General SQL Database Question & Answer
- Backup, Recovery and Disaster Recovery
- SQL Server Security
- Integration Services (SSIS) and DTS
Transact-SQL Programming
- DML (SELECT, INSERT, UPDATE, DELETE) Questions
- Stored Procedures, Triggers, & Functions
SQL Server Scripts, Code Samples and SSMS Custom Reports
- All SQL Server Versions
- SQL Server 2005/2008
- SQL Server Management Studio Custom Reports
Customer Service
- Video Requests
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.
SQL Server 2005 DBA Training Videos
SQL Server 2008 DBA Training Videos
Watch this topic
RSS Feed
Email this topic
Print this topic
Threaded
Normal