Re: What's in the transaction log

Ed Avis <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>...
> [EMAIL PROTECTED] (Chris Jack) writes:
> 
> >Are things like 'create proc' commands logged to the transaction log?
> >What about things like DDL 'create table' and 'create index'?
> 
> AFAIK DDL is not written to the transaction log and cannot be rolled
> back.
Hi,
If that would have been the case, then we would'nt have been able to
do any point in time restores in case of dropping tables by mistake.

Thanks

dba