First of all thanks for yr quick reply.

I updated following code in trigger :

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

ALTER TRIGGER [trg_EmpMasterBfNo] ON [dbo].[EmpMaster]

FOR INSERT, UPDATE

AS

IF UPDATE(ContactNo)

BEGIN

IF EXISTS ( SELECT 1 FROM...

Here my Trigger Code :

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

CREATE TRIGGER [trg_EmpMasterBfNo] ON [dbo].[EmpMaster]

FOR INSERT, UPDATE

AS

IF UPDATE(CantactNo)

BEGIN

DECLARE @EntryNo varchar(50)

SET @EntryNo = (select EntryNo from inserted)

DECLARE @OldCantactNo varchar(50)

DECLARE @NewCantactNo varchar(50)

SELECT @OldCantactNo=d.CantactNo,@NewCantactNo=i.CantactNo FROM...

Thanks a lot.

i did it as per your suggestion, it made a difference.

what if i change CompanyName,Region,Source to numeric ID instead of this long string ? does it make any...

Hi Chris,

here i am attaching actual execution plan of View and Main query as you requested.

thanks for help me

Pls help me

i am at critical situation.

HI,

Here i have attached index definitions as you have asked for.

I want to tell you that i have created index only for those fields which are used in my query....

I got the query how to get index details. here my index details

here the plan.

Hi,

Thanks for helping me.

Here the execution plan and definition of 3 tables which are used in my query. I don't know how can i give you index details.

Hi, Jim.

replying after bit of time. but it was due to my IT (Networking) personnel who is not able to open port.

is there any other thing to see ? or...

Hi Jim,

Thanks for reply

i saw configuration settings in my sql server, Default TCP/IP port is 1433.

but i am not able to find 1433 port on firewall.

i tried the following procedure...

Thanks man, for helping me

in answer to your questions :

1. I did not changed anything except indexing on a table. (query,table,data,fields all are as it is)

2. b.fid field is numeric...