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
|
|
|

Error Message

Can anyone shed any light on the following error message
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 01/07/2003
Time: 17:30:59
User: N/A
Computer: XXXXXX1
Description:
17148 :
SQL Server is terminating due to 'stop' request from
Service Control Manager.
Thanks
PeterHello, Peter!
This, AFAIK, is SQL Server telling you it has been told to shut down. The
Event Type is Information. I do not think there is anything to worry about
from a SLQ Server point of view. You may however want to know who and why
your server is shutting down.<grin>
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
: Event Type: Information
: Event Source: MSSQLSERVER
: Event Category: (2)
: Event ID: 17055
: Date: 01/07/2003
: Time: 17:30:59
: User: N/A
: Computer: XXXXXX1
: Description:
: 17148 :
: SQL Server is terminating due to 'stop' request from
: Service Control Manager.
-- Microsoft CDO for Windows 2000|||Thanks Allan, as you said I will just have to figure out
why.
Peter
>--Original Message--
>Hello, Peter!
>This, AFAIK, is SQL Server telling you it has been told
to shut down. The
>Event Type is Information. I do not think there is
anything to worry about
>from a SLQ Server point of view. You may however want to
know who and why
>your server is shutting down.<grin>
>--
>Allan Mitchell (Microsoft SQL Server MVP)
>MCSE,MCDBA
>www.SQLDTS.com
>I support PASS - the definitive, global community
>for SQL Server professionals - http://www.sqlpass.org
>: Event Type: Information
>: Event Source: MSSQLSERVER
>: Event Category: (2)
>: Event ID: 17055
>: Date: 01/07/2003
>: Time: 17:30:59
>: User: N/A
>: Computer: XXXXXX1
>: Description:
>: 17148 :
>: SQL Server is terminating due to 'stop' request from
>: Service Control Manager.
> -- Microsoft CDO for Windows 2000
>
>.
>