Activity overview
Latest activity by GregE
Table rebuild to add column scripted after sproc update to use the new column
Using SQL Compare 14.0.7.13517 (latest) to compare SQL Compare snapshots and
SQL Server 2012 databases. I'm experiencing a problem where a column is added to an existing table, and stored procedure...
I have a similar issue, in which a sproc is being modified to use a new column in a table, before that column has been added to the table. Moving the ALTER TABLE above the sproc update in the script SQL Compare has generated fixes it. SQL Compare is great at resolving other dependencies, why not this? Using SQL Compare 14.0.7.13517 (latest) and SQL Server 2012 databases. EDIT: I've discovered why this table is special in my case - it's not an ALTER TABLE, it's rebuilding the table using a temporary recovery table. I'll create a separate thread for that.
/ comments
I have a similar issue, in which a sproc is being modified to use a new column in a table, before that column has been added to the table. Moving the ALTER TABLE above the sproc update in the scrip...