How can we help you today? How can we help you today?

Datatype not supported in the target database version

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
mark_anderson_us
0

Comments

2 comments

Sort by
  • 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?
    Brian Donahue
    0
  • mark_anderson_us
    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
    mark_anderson_us
    0

Add comment

Please sign in to leave a comment.