Hi Gail,

Sorry for asking this. I'm not a DBA but a middle ware engineer. Please let me know how I can find it and shall give the information to you.

Thanks

Hi Gail,

The thing I noted is

If I include the commit statement as part of the Stored procedure there is no issue at all.

But then the commit will be done for...

Hi Gail,

Please find below the details

CREATE TABLE table1(

[TPType] [varchar](20) COLLATE Latin1_General_CI_AS NOT NULL CONSTRAINT [****] DEFAULT ('vvvvv'),

[BUCode] [varchar](10) COLLATE Latin1_General_CI_AS NOT NULL,

[AccountCode] [varchar](20) COLLATE Latin1_General_CI_AS NOT NULL,

[AccountName] [varchar](250) COLLATE...

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

ALTER PROCEDURE *******

@BU_Code varchar(10),

@vendor_Code varchar(10),

@vendor_Tpid varchar(40),

@vendor_Name nvarchar(250),

@acc_Code varchar(40),

@vendor_EmailId varchar(250),

@vendor_ContactName varchar(250),

@vendor_ContactPhone varchar(250)

AS

declare @error_code int

set @error_code = 0

BEGIN TRAN

Update table1

set...