ERROR MESSAGE:

Server: Msg 542, Level 16, State 1, An invalid datetime
value was encountered. Value exceeds the year 9999.

Thanks,

Ryan Grim

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sql...

Thanks,

Ryan

Seems to me that the data is corrupt. Can you reproduce the problem?

In addition, what is version of SQL Server? What operation are you
performing that will cause "An invalid datetime value was encountered.
Value exceeds the year 9999."?

This posting is provided "AS IS" with no warranties, and confers no rights.

Regards,

Bill Cheng
Microsoft Support Engineer
--------------------
| Content-Class: urn:content-classes:message




| Subject: Re: HELP - SQL Server 7.0 Error - Msg 542, Level 16, State 1
| Date: Wed, 14 May 2003 07:06:56 -0700
| Lines: 45

| MIME-Version: 1.0
| Content-Type: text/plain;
|       charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcMaIhRfZGWRrUWqTu+55aWSNEQ/Nw==
| Newsgroups: microsoft.public.sqlserver.server
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:286732
| NNTP-Posting-Host: TK2MSFTNGXA08 10.40.1.160
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| The CHECKDB operation has been done and corruptions found
| and corrected.  Here is the interesting thing...there is
| a column in one table that is of DATETIME data type and
| contained this value.... 16058-08-30 13:55:00.000 ...how
| is this even possible?  We corrected the record
| containing the incorrect year and rebuilt the indexes for
| that table and everything is functioning properly.  Any
| ideas?
|
| Thanks,
|
| Ryan