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

Bug? - SQLCompare 6.1 doesn't refresh views with drop column

It appears that if a table is only altered by dropping one or more columns, SQLCompare 6.1.053 does not generate sp_refreshview statements for assciated views causing the following error when one of those existing views is accessed:

Msg 4502, Level 16, State 1, Line 1
View or function '<view>' has more column names specified than columns defined.
slhale
0

Comments

2 comments

Sort by
  • Andras B
    slhale wrote:
    It appears that if a table is only altered by dropping one or more columns, SQLCompare 6.1.053 does not generate sp_refreshview statements for assciated views causing the following error when one of those existing views is accessed:

    Msg 4502, Level 16, State 1, Line 1
    View or function '<view>' has more column names specified than columns defined.

    Many thanks for reporting this. I have raised this as a bug, and we will fix this in a future version.

    Regards,
    Andras
    Andras B
    0
  • Eddie D
    I am pleased to inform you that we have fixed this problem in the recently released SQL Compare V.7.

    If you have a valid Support & upgrades option, you can download SQL Compare V.7 using the 'Check for updates' mechanism (SQL Compare GUI ->Help ->Check for updates)

    or download using this link: HERE

    SQL Compare V.7 will install along side any previous versions of the software.

    Many Thanks
    Eddie
    Eddie D
    0

Add comment

Please sign in to leave a comment.