FIX: Msg 267 and 202 on Stored Proc If Table Is Dropped and Re-created

MORE INFORMATION

create table t1 (i1 int, i2 int)
go

create proc p1 as
declare @i1 int
create table #tt (i1 int)
insert #tt values (1)
declare cc cursor for select i1 from #tt
open cc
fetch cc into @i1
while (@@fetch_status<>-1)
begin
   update t1 set i2=i2+1 where i1=@i1 -- This forces a recompile
   fetch cc into @i1
end
close cc
deallocate cc
select * from #tt -- Raises an error when p1 is invoked for the 2nd time
go

exec p1
go

drop table t1
go
create table t1 (i1 int, i2 int)
go
exec p1  -- Raises 267 error
go
exec p1 -- Raises 202 error