XPost: microsoft.public.sqlserver.programming   
   From: esquel@sommarskog.se   
      
   Gene Wirchenko (genew@ocis.net) writes:   
   >      I was thinking it would then be temporary.  Does that not work   
   > with cursors?   
      
   Nope. Actually, since you asked, I had to test:   
      
   create procedure testis as   
   declare  #cur cursor for select name from sys.columns   
   open #cur   
   fetch #cur   
   go   
   exec testis   
   exec testis   
   go   
   deallocate #cur   
   drop procedure testis   
      
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Books Online for SQL Server 2005 at   
   http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx   
   Books Online for SQL Server 2000 at   
   http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)