Rows Affected- But Update Not Physically Occurring

I have a mixed mode account setup with exec permissions granted on my stored procedures. I am running an sp that is editing a member, and if i run it using my query analyzer with the same login, my sp writes to the db. however, if i'm calling it through my web app (asp.net) it doesn't. here is my sp code:





USE DATABASE


--DROP PROC sp_EditMember


GO





--Create the stored procedure


CREATE PROCEDURE sp_EditMember


@member_id smallint,


@last_name nvarchar(50), --not nullable


@first_name nvarchar(50),


@spouse_name nvarchar(50),


@street_address nvarchar(50),


@city nvarchar(35),


@state nvarchar(5),


@zip_code nvarchar(15),


@zip_4 nvarchar(4),


@area_code nvarchar(10),


@phone_number nvarchar(20),


@email nvarchar(50),


@child_1 nvarchar(30),


@child_2 nvarchar(30),


@child_3 nvarchar(30),


@child_4 nvarchar(30),


@child_5 nvarchar(30),


@member_status nvarchar(20),


@member_exp nvarchar(10),


@plaques_st nvarchar(10)





AS


BEGIN TRAN


UPDATE Members


SET last_name = @last_name, first_name = @first_name,


spouse_name = @spouse_name, street_address = @street_address,


city = @city, state = @state, zip_code = @zip_code, zip_4 = @zip_4,


area_code = @area_code, phone_number = @phone_number, email = @email,


child_1 = @child_1, child_2 = @child_2, child_3 = @child_3,


child_4 = @child_4, child_5 = @child_5,


member_status = @member_status, member_exp = @member_exp,


plaques_st = @plaques_st





WHERE member_id = @member_id





IF @@ERROR <> 0


BEGIN


ROLLBACK TRAN


END


ELSE COMMIT TRAN


GO


--------------------------------------





on my app side- i've already ensured the datatypes match up and the sizes are all ok (except for member_id, the variable is an int and i pass it as a small_int- the number is ranging from 1000-10000).





any troubleshooting on this?





thanks in advance,





sudeep.