Options

Computed Column formula doesn't show as different

jdarraghjdarragh Posts: 2
edited October 22, 2007 1:06PM in SQL Compare Previous Versions
Using the latest version 6.1.0.53 Professional Edition.

Comparing two SQL Server 2005 dbs, a table with a computed column did not display as different when the computation was different for the column. The computed column is Persisted.

Is there a configuration setting that will show these tables as different?
· Share on Twitter

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Thanks for your post. Is the computed column allowing NULLS on one side, and not allowing NULL on the other? I think we may have an open issue about this.

    It would also help tremendously if you could post the DDL to create these two tables because that would make it easy to reproduce the problem.

    Thanks.
    · Share on Twitter
Sign In or Register to comment.