I just noticed that my Quote table did not have the foriegn key to the OrderDetail table.

I have the Quote table with a foreign key to the OrderDetail table in...

Thank you

MONEY sql datatype

decimal .net c# datatype

The CartID column is a stored id in a cookie and or the session in my .net application.

The ShopperID column is the logged on membership Guid userID

CREATE TABLE [dbo].[utbCart](

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

[CartID] [varchar](20) NULL,

[ShopperID] [uniqueidentifier] NULL,

[ProductID] [int] NOT NULL,

[ReferenceName] [varchar](70) NULL,

[Quantity] [tinyint] NOT NULL,

[ModifiedDate] [datetime] NOT NULL,

[UnitCost] [money] NULL,

[ExtendedCost] AS ([UnitCost]*[Quantity]),

[IsPreBuilt] [bit] NOT NULL,

...

HEY wait a minute,, do not go anywhere 😉

I am not in a domain just in WORKGROUP

HELP DELIMA ALERT !!!

When developing the app I was finally able to use filestream by setting nt authorityetwork in the logins and permissions on the correct database.

NOW,,, I have...

...

Now that I am thinking about it...

I am finally able to grasp this flow of security and check points with-in the sql server instance. Only took 4 years, but who's...

Never mind.

I mapped the login to the desired database.

Under permission on the database I gave NT exec, insert, update permission and it works.

I have not give it a shot yet becuase I am finializing an app. Switching gears may dislocate brains cells... 😉

That is exactly what i am experiencing .

Thanks for the notes...

I will have to be carefull with this. Becuase dropping a table to add a column seems a bit much.

I found a way to do it.

-- Add a new column to the table

ALTER TABLEdbo.utbStorefrontDoor

ADD OverAllHeight varchar(10) NULL

GO

Just use code and not the designer.

I was just thinking about your status yesterday.

I am going to dig into it in a day or so.

Will let you know if I hit any crazy stuff.

Thank you for...

Thanks.

I will look forward to your response.