Stored Proc && Transaction Log Size Problems!!!!!

For some reason, my stored procedure which is kicked off by VB.NET is growing the log file for the database in question by gigs, very fast. Why is it doing this?

The code:

Sub Main()

objConn.Open()
Dim cmdSql As New SqlClient.SqlCommand("IT_sss_Collector_DotNet", objConn)
cmdSql.CommandType = CommandType.StoredProcedure
cmdSql.CommandTimeout = 1000

Dim reader As SqlDataReader = cmdSql.ExecuteReader()

Dim ppa_rowcount As Integer
ppa_rowcount = 0

If reader.HasRows() Then ' test to see if there is any data in the reader
reader.Read()
ppa_rowcount = Convert.ToInt16(reader("pcount"))
End If
reader.Close()

'Dim ppa_rowcount As Integer = Convert.ToInt16(cmdSql.ExecuteScalar())

MsgBox(ppa_rowcount)

If ppa_rowcount > 0 Then
MsgBox("got here")
RunsssReport()
End If

objConn.Close()

End Sub


The Stored proc:

http:\www.webfound.netstoredproc_growinglogfile.txt

the log is 29 gigs! this is a copy of a production database running on my test server. The production db log is only 15 gigs. How do I manage this and why it is growing at such a crazy porportion just from running this simple stored proc with a cursor???????