Table added columns-sync successfully-but col. still missing
i had to add two additional columns to a table on my developer database. a user defined function that queried the table with * for all columns of that table made some problems. i "modify"ed the UDF without actually altering anything - just pressing "execute" in management studio (mssql 2005!)
please see http://forums.asp.net/t/1359702.aspx for additional info about it.
everything was working on my developer machine + database after that. i wanted to sync it with the live DB but now i ran into similar problems:
i synced the table with the two added columns successfully but when i query the table in management studio on the live DB the two new columns won't appear - even sql compare isn't showing any differences on this table anymore. how to "refresh" the schema?
as a result of this i can't sync some other UDF functions that are querying this two new columns.
please help me.