We have done a couple of different things to work around this behavior. You can force the proc to recompile like:

ALTER PROCEDURE [usp_testRecompile]

@begin bigint,

@end bigint,

with recompile

as

set nocount on

SELECT column1, column2,...

Are you running replication with this database? If you are, and the distribution agent has stopped for some reason, the log file will continue to grow until the distribution agent...