Re: Roll Forward Logical Log

jh wrote: > > Hi, > > Just wondering if I create my temp table 'with no log' option in my > stored procedure. Do I have a problem rolling forward my logical log as the > temp table will not be logged ?? No temp tables left over after a crash are dropped when the engine comes online anyway and the sessions that owned them are gone and can no longer access them anyway. You will just save the time and trouble of rolling forward all those temp tables just to drop them afterward. Art S. Kagel