Thank you . It works .

****** Object: Table [dbo].[tdsMSMCA_Askk] Script Date: 08/14/2013 17:45:48 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[tdsMSMCA_Askk](

[ID] [int] IDENTITY(1,1) NOT NULL,

[Field1] [varchar](255) NULL,

[Field2] [varchar](255) NULL,

[Field3] [varchar](255)...

It does the same with cluster index . must be something else.

Thank you Luis !

I tested your solution on real data and for some reason it does not work . ID incremented for field1 value='H' .The rest script updated with...

THANK YOU.

I guess this is not going to be problem to reverse it if I already enabled AWE in sp_configure

Hello !

I am kind of looking for the same answers.

Do I have to enable AWE and switch \3GB on 64 BIT SERVER 8GB RAM , Windows 2003 Standard /SQL 2005...

can't this be done by using union all

INSERT INTO @tempEmail (email_address, DisplayName, P.ProjectID, OrganizationID, type)

SELECT DISTINCT 'name1@company.com','Insurance Company', H.ProjectID, H.OrganizationID, 3

FROM ReportOpenItemsOverDue H

WHERE H.InsuranceID = 26

UNION ALL

SELECT DISTINCT

Hello Kenneth ! Thanks for looking into this issue. I discovered this problem when I actually applied the same syntax in the second view.

FROM

    purchase p,

    pur_list l,

    sf_po_xref_vw x

  WHERE...

Thanks again!

I will follow your recommendations and will give it to try. What do You think about adding some logic after insert completed that will check transaction in both...

Hello Lowell ! Thanks for looking into my problem. I would think so too that insert never happened on delivery details table. Still have few cases when actually theatre received...