Hi Trent,

I am creating a new table with a field type "DateTime2" and when deploying to SQL2008 I get an error when trying to create the xx_Insert store procedure:







What am I doing wrong?

Edhy Rijo

Nothing.  We will have to change the auto-generated sprocs.  I will add this to the list to check on the new data types when dynamically creating the SPROCS for new data types.

Great! thanks. I'll use "DateTime" instead until this is available.

Edhy Rijo

Are the new datatypes supported yet? I am on 1.7.0.2 trying to use date and time data types and there are no default values available and I get the error above when trying to deploy.

Keith Chisarik

Hey Keith,



First, StrataFrame does support SQL Server 2008 and is predominately the only database that we use. Even if you do not use the new data types, SQL Server it is significantly faster than previous versions and supports a lot more within SPROCS, etc.



The DDT itself still needs to be updated to support some of the new data types. There have been more pressing things on the agenda so this has been pushed back until the first quarter as there is little to no demand for some of the new data types. There have been a few inquiries (as you can see via this post), but the SQL Server 2008 is supported for distribution on all data types except some of the newer data types, which are not an absolute necessity anyway...they just make a few things slightly easier.