Datatype not supported in the target database version

mark_anderson_us

Severity: High
Object: SG_WIP_BI
Title: The datatype of the parameter @ EndDate of stored procedure [dbo].[SG_WIP_BI] is not supported in the target database version.

Hi guys

Any idea why I'm getting above, when deploying schema changes. The source and target are both on SQL 10.50.2550. When first installed the target was on an older release, but has since been brought up to same level. The variable is a Date type

Thanks

Mark

Brian Donahue

Hi Mark,

It sounds like SQL Server is returning this error - are you checking both the server platform version as well as the compatibility level of the database itself?

mark_anderson_us

Brian Donahue wrote:

Hi Mark,

It sounds like SQL Server is returning this error - are you checking both the server platform version as well as the compatibility level of the database itself?

Never thought to check compatibility level. Will take a look next time I connect