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

Bug in version 4.1.0.59

I found a bug when I try to compare a two databases in MSSQL 2005. The application (SQL Compare) store my VIEW into a TABLE. It should be stored in a VIEW folder instead.

I was using SQL compare version 4.1.0.59
rnguyen
0

Comments

3 comments

Sort by
  • Brian Donahue
    If you have a look at this object in SQL Management Studio, and create a SQL script for it, does it begin with CREATE VIEW or CREATE TABLE? I'd assume that SQL Server 2005 has its' wires crossed somewhere.
    Brian Donahue
    0
  • rnguyen
    When I script the VIEW It said CREATE VIEW.
    rnguyen
    0
  • Brian Donahue
    Can you please try running sp_refreshview against this view.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.