Question: I have shifted our live server to a new server configuration Windows 2008 server and sql server 2008.

But I am having following exception while adding date field data :

> 
> 2011-05-15 18:00:44,263 ERROR Error
>  caught : the details of the error are 
>  System.Data.SqlTypes.SqlTypeException:
>  SqlDateTime overflow. Must be between
>  1/1/1753 12:00:00 AM and 12/31/9999
>  11:59:59 PM. at
>  System.Data.SqlTypes.SqlDateTime.FromTimeSpan(TimeSpan
>  value)
> 
> 
> 

But the same code is working fine on local machine and was also working fine on old server.

I have even changed the date field explicitly into **"mm/dd/yy"** format.
But still not found the solution.
Can anyone provide me the solution.

Answer: 
There's actually three things: A Website, a Store and a Store View.

The most important part about Websites is that each websites has its unique customer and order base.

Stores can be used to define for example different (looking) stores with the same information.

Store Views are mostly used to handle different languages on your website. You will typically have one Store View per language.
Website:

* Possible to maintain a separate customer base for the website, or can
share the customer accounts with all websites
* Different base currency can be defined
* Different order base can be maintained (Need citation on this one)
* Different prices can be given for the website using a configuration
setting or can share the price globally
* Different Website URLs can be used or can share the same website URL
(Magento keeps unique cookies)

Store:

* Customer accounts are shared among all the stores under a specific
website
* Same base currency
* Same Price
* Product can be assigned store specifically
* Can have different root category configuration

Store View:

* Common practice is to distinguish between different language views
for store
* Different display prices
* Category settings can be different
* Same root category for all store views

**Inventory is global across all the websites and stores.** Either the product is IN STOCK or not! If need different inventories, have to use third party modules

Hope this helps....