BUG: Docerr: Nested Stored Procedure and Temporary Objects

• Microsoft SQL Server version 4.2 for OS/2

SYMPTOMS

On page 292 of Transact-SQL "User's Guide," it is incorrectly stated that:

   If you execute a procedure that calls another procedure, the called
   procedure can access all objects except temporary tables created by
   the first procedure.

   If you execute a procedure that calls another procedure, the called
   procedure can access all objects created by the first procedure.

Example

For example, consider the following where proca is the calling procedure and procb is the called procedure:

   create proc proca as
        create table #t1 (i int)
        execute procb
   go
   create table #t1 (i int)
   go
   create proc procb as
        if not exists (select name from tempdb..sysobjects
           where substring(name,1,3)='#t1')
           create table #t1 (i int)
   select * from #t1
   go
   drop table #t1
   go
   execute proca
   go