If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

The above runs fine as a script, or seperated into three sp's. Wrapping the
ALTER TABLE statement into transaction and committing it prior to the UPDATE
statement didn't help. I think it has something to do with the ALTER TABLE
statement forcing the sp to recompile, thus the errors with the UPDATE
statement.

Is this just a common-sense no-no for stored procedures? Or am I missing
something with the code?