Bug in version 4.1.0.59

rnguyen · February 21, 2006 11:55PM

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 · February 22, 2006 7:17AM

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 · February 22, 2006 4:52PM

When I script the VIEW It said CREATE VIEW.

Brian Donahue · February 23, 2006 11:18AM

Can you please try running sp_refreshview against this view.

Bug in version 4.1.0.59

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk