I was working in a test enviroment on a Windows 2003 Server with SQL Server 2005 and the views I created run fine. Now I have moved over to our production enviroment and I am receiving an error.
Error converting data type DBTYPE_DBTIMESTAMP to datetime.
There are no bad dates in the table however there is a date of 1/15/1905. I cannot figure out what is the bad date. Is there a setting in SQL I can change? I am running queries against a linked server.