Error Message SqlDateTime

• abdielmomo

  SSC-Addicted

  Points: 479

  More actions

  April 10, 2013 at 5:25 am

  #273314

  Please, When I run a Select on my table i receive this message: "Une erreur s'est produite lors de l'exécution du lot. Message d'erreur : Dépassement SqlDateTime. Doit être compris entre 1/1/1753 12:00:00 AM et 31/12/9999 11:59:59 PM." and It's not possible to read data in my table. WHat can i do to fix this problem without loosing data in my table?

  NB: I am using sql server 2008 and the command is "Select * from mytable"

  Thanks in advance

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  April 10, 2013 at 6:38 am

  #1605191

  abdielmomo (4/10/2013)

  ---

  Please, When I run a Select on my table i receive this message: "Une erreur s'est produite lors de l'exécution du lot. Message d'erreur : Dépassement SqlDateTime. Doit être compris entre 1/1/1753 12:00:00 AM et 31/12/9999 11:59:59 PM." and It's not possible to read data in my table. WHat can i do to fix this problem without loosing data in my table?

  NB: I am using sql server 2008 and the command is "Select * from mytable"

  Thanks in advance

  Care to translate the error message into English?

  Thanks.

• J Livingston SQL

  SSC Guru

  Points: 51550

  More actions

  April 10, 2013 at 6:50 am

  #1605195

  Lynn Pettis (4/10/2013)

  ---

  abdielmomo (4/10/2013)

  ---

  Please, When I run a Select on my table i receive this message: "Une erreur s'est produite lors de l'exécution du lot. Message d'erreur : Dépassement SqlDateTime. Doit être compris entre 1/1/1753 12:00:00 AM et 31/12/9999 11:59:59 PM." and It's not possible to read data in my table. WHat can i do to fix this problem without loosing data in my table?

  NB: I am using sql server 2008 and the command is "Select * from mytable"

  Thanks in advance

  Care to translate the error message into English?

  Thanks.

  "An error occurred during the execution of the batch. Error: Overflow SqlDateTime. Must be between 1/1/1753 12:00:00 AM and 31/12/9999 11:59:59 PM ".

  think we need a few more details on what OP is trying to do

  ________________________________________________________________
  you can lead a user to data....but you cannot make them think
  and remember....every day is a school day