Thread: Database Question

I've been trying to insert data using a sql script and get the following error;

Msg 8169, Level 16, State 2, Line 2
Conversion failed when converting from a character string to uniqueidentifier.

SET IDENTITY_INSERT [aspdnsf_c4zone].[dbo].[Product] ON
INSERT INTO [aspdnsf_c4zone].[dbo].[Product] ([ProductID], [ProductGUID], [Name], [Summary], [Description], [SEKeywords], [SEDescription], [SpecTitle], [MiscText], [SwatchImageMap], [IsFeaturedTeaser], [FroogleDescription], [SETitle], [SENoScript], [SEAltText], [SizeOptionPrompt], [ColorOptionPrompt], [TextOptionPrompt], [ProductTypeID], [TaxClassID], [SKU], [ManufacturerPartNumber], [SalesPromptID], [SpecCall], [SpecsInline], [IsFeatured], [XmlPackage], [ColWidth], [Published], [Wholesale], [RequiresRegistration], [Looks], [Notes], [QuantityDiscountID], [RelatedProducts], [UpsellProducts], [UpsellProductDiscountPercentage], [RelatedDocuments], [TrackInventoryBySizeAndColor], [TrackInventoryBySize], [TrackInventoryByColor], [IsAKit], [ShowInProductBrowser], [IsAPack], [PackSize], [ShowBuyButton], [RequiresProducts], [HidePriceUntilCart], [IsCalltoOrder], [ExcludeFromPriceFeeds], [RequiresTextOption], [TextOptionMaxLength], [SEName], [ExtensionData], [ExtensionData2], [ExtensionData3], [ExtensionData4], [ExtensionData5], [ContentsBGColor], [PageBGColor], [GraphicsColor], [ImageFilenameOverride], [IsImport], [IsSystem], [Deleted], [CreatedOn], [PageSize], [WarehouseLocation], [AvailableStartDate], [AvailableStopDate], [GoogleCheckoutAllowed], [SkinID], [TemplateName])
VALUES ('', '', 'Redken ringlet 07 curl perfector 180ml', '', '', 'Redken ringlet 07 curl perfector. Ban the frizz, define the shape, revive the shine. Curl refining cream-gel activates and rejuvenates curls and waves with weightless control. Exclusive Bonding System and powerful anti-frizz agents help block humidity to deliver lasting frizz-free, crunch-free curl perfection.', 'Redken ringlet 07 curl perfector. Ban the frizz, define the shape, revive the shine. Curl refining cream-gel activates and rejuvenates curls and waves with weightless control. Exclusive Bonding System and powerful anti-frizz agents help block humidity to deliver lasting frizz-free, crunch-free curl perfection.', '', NULL, '', NULL, '', 'Redken ringlet 07 curl perfector. Ban the frizz, define the shape, revive the shine. Curl refining cream-gel activates and rejuvenates curls and waves with weightless control. Exclusive Bonding System and powerful anti-frizz agents help block humidity to deliver lasting frizz-free, crunch-free curl perfection.', '', 'Redken ringlet 07 curl perfector. Ban the frizz, define the shape, revive the shine. Curl refining cream-gel activates and rejuvenates curls and waves with weightless control. Exclusive Bonding System and powerful anti-frizz agents help block humidity to deliver lasting frizz-free, crunch-free curl perfection.', '', '', '', 1, 1, '', '', 1, NULL, 0, 0, 'product.tabbedui.xml.config', 4, 1, 0, 0, 2, NULL, 0, '', '', 0, NULL, 0, 0, 0, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, 0, 'Redken ringlet 07 curl perfector 180ml', '', NULL, NULL, NULL, NULL, '', '', '', '', 0, 0, 0, '20091208 03:06:32.800', 20, NULL, '20091208', NULL, 0, 0, '')
SET IDENTITY_INSERT [aspdnsf_c4zone].[dbo].[Product] OFF

Got sorted, it seems to be the missing GUID

Yep...ProductGUID is required and can't be blank. If inserting and you don't have a GUID, just use SQL's default syntax for a uniqueidentifier, newid().