Re: Logged temporary tables (was: Fill my rootdbspace, please)

From: Jonathan Leffler <jleffler@earthlink.net> > >Mark Stock wrote: > > > [...sage advice about rootdbs...] > > > Moving your logs, databases and tables to other dbspaces is quite > > straight forward. It's usually temp tables that cause the problem, or in > > particular logging temp tables. These cannot be created in temp > > dbspaces. > >Can anyone think of a sound reason for wanting logged temp tables? Uhh, uhh, uhh...it'll come to me in a minute...nope. >Why wasn't the default changed to 'WITH NO LOG' once the option >was introduced, with the analogous explicit 'WITH LOG [IN (dbspace1, >dbspace2, ...)]' being created for those circumstances that someone >will describe when a logged temp table is actually of some benefit? Much better idea. Maybe we _should_ have you put in charge of product development! :-) ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com