thank you!

Because the second procedure is running inside the first one, after commit trans, first all transactions will be commited and after that will the second procedure be executed? I am...

Yes, table3 has refrecid row.

Hi all,

I do not want to confuse people, especially when they are trying o help me.

Below is a sample of how stored procedure seems :

PROC1

-----Procedure1 is calling with...

The second procedure( which does not work correct some times) is being executed after a "Commit Transaction" inside the first proc. Is there a possibility that rows are still...

Hi,

I have created a new table with name 'testjohn '

CREATE TABLE [dbo].[testjohn](

[ITEMID] [nvarchar](25) NOT NULL,

[AVAILPHYSICAL] [numeric](28, 12) NOT NULL,

[INVENTDIMID] [nvarchar](20) NULL,

[INVENTLOCATIONID] [nvarchar](10) NOT NULL,

[MODIFIEDDATETIME] [datetime] NOT NULL,

CONSTRAINT [I_ITEMINVENTIDX] PRIMARY...

You are right, there is another trigger that gives RecId ( A field that our ERP needs).

I will check it.

Thanks for the reply

Thanks, I will try Insert Statement.

Hi,

It is TEMPINVENTSUM.

Thanks

Hi,

Our ERP is Microsoft Dynamics AX (DAX). The trigger is on table InventSum

CREATE TABLE [dbo].[INVENTSUM](

[ITEMID] [nvarchar](25) NOT NULL,

[POSTEDQTY] [numeric](28, 12) NOT NULL,

[POSTEDVALUE] [numeric](28, 12) NOT NULL,

[DEDUCTED] [numeric](28,...

Again update from trigger is very slow.

HI,

This is the code

ALTER TRIGGER [dbo].[CREATE_ITEM] ON [dbo].[ITEMMASTER]

AFTER INSERT,UPDATE

AS

DECLARE @ITEMID NVARCHAR(21)

DECLARE @ITEMNAME NVARCHAR(40)

DECLARE @AMOUNT NUMERIC(15,2)

DECLARE @REFRECID NUMERIC(18,0)

DECLARE @UNITID NVARCHAR(5)

DECLARE @ITEMGROUPID NVARCHAR(17)

DECLARE @WHOLESALEAMOUNT NUMERIC(15,2)

DECLARE @AMDEVICEBRANDID NVARCHAR(5)

select @ITEMID=ITEMID COLLATE Greek_CS_AS...

Do I have to manually update stats when I move cluster?

I have observe,some times, a very slow select to some big tables and views when I move from one node...

Hi,

First of all thank you for your answer. The aim is high availability and minimal data loss.

From what I have read, I have come to the conclusion for clustering and...

Great! Thanks.