The proc does have transaction in it, but I'm printing a message before the first "BEGIN TRAN" statement.

Speaking of checkpoints....does anyone know of a DBCC command to force one to occur? I was curious if you can force a database using the Simple recovery model to clean up its transaction log on demmand.