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