Posted by Erland Sommarskog on 05/01/07 11:42

Mork69 (mleach@bigfoot.com) writes:
> Regarding the statement that it is a "non logged" operation -
> obviously all operations write to the transaction log in some way, I
> was just using the term that is in general use that was erroneously
> started by Books Online.

Actually, not even that. Books Online for SQL 2000, is very careful to
talk about minimally logged. I looked in Books Online for SQL 6.5, which
indeed talks about non-logged, but that was loooong ago. And the
architecture was different way backk then.

> In any case, as the only records that are written are merely to log a
> table's creation.

Not only. The extent allocations are also logged. If they weren't and
the operation failed on illegal convert operation half-way through, you
would be left with a table that would have a couple of rows in it.


--
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

[Back to original message]