I was also a late comer to socail networking. I have deliberatly limited myself to facebook for non-work and linked in for work. That has given me a...

I don't know why but when I use a query window to to the inserts it works. Now my head hurts.

I am typing (inserting) new data.

USE [GAGInventory]

GO

/****** Object: Table [dbo].[StoreOldShippingAddressJoin] Script Date: 02/02/2009 10:59:51 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[StoreOldShippingAddressJoin](

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

[StoreID] [int] NOT NULL,

[ShippingAddressID] [int] NOT NULL,

[CreatedDate]...

I need to add this records quickly and I don't have time to add the UI right now. Yes there is a trigger on this table.

set ANSI_NULLS ON

set QUOTED_IDENTIFIER...

To be clear I am not doing this via code. I am typing directly into the table row. here is the ddl

USE [GAGInventory]

GO

/****** Object: Table [dbo].[Store] ...

thanks you guys/gals rock. That is generally all I need is a pointer in the right direction.

Thanks.

WOW! Thank you very much. I will study it and try to write better code from now on.

Ouch! That is harsh. I guess I am writing it badly because I don't know all the details on how to write it better and it is for...

Thanks Gila that was exactly the issue. I hate it when it is something like that.

To the other point. Yes I understand injection but this is...

Learn to say NO early and often :w00t:

Actually I would say that the main thing is that you understand what is happening in your userbase re:DB access and head off...