Error message- please help!

Hi,
I'm hoping someone can she some light on this at all. I'm using SMS server
(W2ksp3) with SQL 2K sp3. and i keep getting this error message(thousands
since midnight):
SMS_INVENTORY_DATA_LOADER Microsoft SQL Server reported SQL message 213,
severity 16: Insert Error: Column name or number of supplied values does not
match table definition. Please refer to your SMS documentation, SQL
documentation, or the Microsoft Knowledge Base for further troubleshooting
information.
I don't know how to find out what table this is referring to and i can't
seem to find out anything more about this.
I would *REALLY* appreciated any help at all as it is not doing favours for
my SMS server- slowly killing it!
No-one on any SMS sites/newsgroup have encountered this error.
Does anyone know anything about this error?
Thanks so much
JaneHi Jane,
Can you reproduce this error easily? If you can, then what you can try is launch SQL Profiler, start a new trace. Then reproduce the error. Review the profiler trace for more
information. It should show you more information on database, objectid etc.
Sincerely,
Yih-Yoon Lee [Microsoft]
Microsoft SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights. Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
--
| From: "JM" <jane.mcleish@.gcal.ac.uk>
| Subject: Error message- please help!
| Date: Thu, 25 Sep 2003 15:39:08 +0100
| Lines: 23
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <uND76P3gDHA.1748@.TK2MSFTNGP10.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: 193.62.246.37
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:308322
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Hi,
| I'm hoping someone can she some light on this at all. I'm using SMS server
| (W2ksp3) with SQL 2K sp3. and i keep getting this error message(thousands
| since midnight):
|
| SMS_INVENTORY_DATA_LOADER Microsoft SQL Server reported SQL message 213,
| severity 16: Insert Error: Column name or number of supplied values does not
| match table definition. Please refer to your SMS documentation, SQL
| documentation, or the Microsoft Knowledge Base for further troubleshooting
| information.
|
| I don't know how to find out what table this is referring to and i can't
| seem to find out anything more about this.
| I would *REALLY* appreciated any help at all as it is not doing favours for
| my SMS server- slowly killing it!
| No-one on any SMS sites/newsgroup have encountered this error.
|
| Does anyone know anything about this error?
|
| Thanks so much
| Jane
|
|
|