I can't find in the official documentation if SQL Server 2005 supports the datetime2
data type.
Does SQL Server 2005 support datetime2
7.6k Views Asked by ahmd0 At
3
There are 3 best solutions below
0

Open your EDMX in a file editor (or “open with…” in Visual Studio and select XML Editor). At the top you will find the storage model and it has an attribute ProviderManifestToken. This has should have the value 2008. Change that to 2005, recompile and everything works.
NOTE: You'll have to do this every time you update the model from database.
Apparently it does not. Here are the supported data types.
EDIT:
According to the following sources datetime2 was introduced in SQL Server 2008.
http://blogs.msdn.com/b/manisblog/archive/2007/08/28/sql-server-2008-enhancements-in-date-and-time-data-types.aspx
https://web.archive.org/web/20211020150018/https://www.4guysfromrolla.com/articles/101508-1.aspx