SQL Transaction Times Out

Hello everyone,

I have an odd issue and I can't seem to figure it out.  I am using SQL Server 2005 and I am using Transactions in combination with Try/Catch blocks.  My query (executing the stored procedure) never seems to finish the query in query analyzer.  I have removed all statements that exectute or select, etc upon the database except for a  simple Select 'test' as test so I would have something in my Begin/End blocks. Below is my stored proc:

ALTER PROCEDURE [dbo].[ar_mainCheckRecon]

@tripID int,

@payment money,

@adjustment money,

@serviceType tinyint,

@checkTpId int,

@checkTlId int,

@checkNbr varchar(20)

AS

BEGINSET NOCOUNT ON;

BEGIN TRY

BEGIN TRAN select 'test' as test

 

 

END TRY

BEGIN CATCH

RAISERROR('Error commiting transaction', 16,1)

 ROLLBACK TRAN

SELECT '0' as success

END CATCH

 

COMMIT TRANSELECT '0' as errorCode

 

END

I call upon the sproc by running this line in query analyzer:

exec ar_mainCheckRecon 433636, 0, 500, 0, 500, 0, 23

Is there something I am overlooking as to why the query keeps running and never stops? My current execution time is at 3 mins accoring to query analyzer!

Thanks,
John