Message	"Invalid column name 'LastName'.
	Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. 
	Previous count = 0, current count = 1.

ALTER PROCEDURE [dbo].[wsp_UpdateContactProfile]
	(
	@contactCode char(30),
	@prefix char(20),
	@firstName char(50),
	@middleName char(50),
	@lastName char (50)
	)
AS
BEGIN
	SET NOCOUNT ON;
		BEGIN TRAN
		 -- Will create a backup record of existing Contact
			INSERT INTO ContactBackup(ContactCode, 
					Prefix, 
					FirstName, 
					MiddleName, 
					LastName)
				VALUES(@contactCode,
					@prefix,
					@firstName,
					@middleName,
					@lastName)
	     		IF @@ERROR <> 0
   			BEGIN
				ROLLBACK TRAN
				return 10
   			END
			
			UPDATE Contact SET 
				Prefix = @prefix,
				FirstName = @firstName,
				MiddleName = @middleName,
				LastName = @lastName
				where contactCode = @contactCode
			IF @@ERROR <> 0
   			BEGIN
				ROLLBACK TRAN
				return 11
   			END
		
		COMMIT TRAN
END
GO

quote:

---

I wanted to test how the transactions are working and renamed with purpose the column LastName from ContactBackup table to LastName2.

---