Dates 1900-2078; only range accepted in smalldatetime 2

[chequi]

Hello:

I am trying to place dates prior to 1900 and beyond 2078
in a SQL 2000 table (smalldatetime field) and I am getting
an overflow error message.

I need help, please.

Thanks.

Chequi

 

[BSman]

If you don't change the field type to datetime, you're out of luck.

 

[SQLBill]

Use DATETIME not SMALLDATETIME. DATETIME accepts between 1753 and 9999.

Refer to BOL - DATETIME datatype

-SQLBill