Bug in version 4.1.0.59

rnguyen

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

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.

rnguyen

When I script the VIEW It said CREATE VIEW.

Brian Donahue

Can you please try running sp_refreshview against this view.