begin and end transaction and transaction log

From: Kruton <wmlyerly@xxxxxxxxx>
Date: Tue, 11 Dec 2007 20:26:01 -0800 (PST)

Hello everyone,
This is more of an architectural question about SQL Server. Can
someone please explain why when I perform a query such as the one
below that updates a table using begin and end transaction I am unable
to programmatically truncate the transaction log. The only way I have
found to truncate the transaction log is to stop and start the SQL
Server Service. Does this transaction use the tempdb? Is that why I
am unable to truncate the transaction log? Is there a better way to
do this?

Begin trans T1

Update sometable
Set random_row = 'blah'

End trans T1

Thanks!
.

Follow-Ups:
- Re: begin and end transaction and transaction log
  - From: Erland Sommarskog

Prev by Date: Re: Database/Table Design Question - Object/Event Model
Next by Date: Re: Database/Table Design Question - Object/Event Model
Previous by thread: SQL Server writers, we need you!
Next by thread: Re: begin and end transaction and transaction log
Index(es):
- Date
- Thread

Relevant Pages

Re: Insert Into Without Log
... transaction log. ... For instance a truncate can be rolled back if it is within ... Looking for a SQL Server replication book? ... > "Hilary Cotter" ha scritto nel messaggio ...
(microsoft.public.sqlserver.fulltext)
Re: begin and end transaction and transaction log
... found to truncate the transaction log is to stop and start the SQL ... If you run with full recovery and want to be table to restore to a point ... Books Online for SQL Server 2005 ...
(comp.databases.ms-sqlserver)
Re: begin and end transaction and transaction log
... found to truncate the transaction log is to stop and start the SQL ... If you run with full recovery and want to be table to restore to a point ... Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books ... ...
(comp.databases.ms-sqlserver)
Re: begin and end transaction and transaction log
... to programmatically truncate the transaction log. ... found to truncate the transaction log is to stop and start the SQL ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
(comp.databases.ms-sqlserver)
Re: Transaction log and tempdb
... - Is it possible to reduce the size of the transaction log fil during ... an execution? ... It sounds as if you are the database is in full recovery. ... If I execute that script sql server seems ...
(comp.databases.ms-sqlserver)