I am getting this error when attempting to insert a uniqueidentifier into a
table through a Stored Procedure & even direct SQL in Query Analyzer. I have
searched and tried numerous alternatives ALL with no success ...

Perhaps there is a Database setting that I am missing?

Kinda desperate and don't know what else to try,  so any assistance would be
greatly appreciated!

Thank You,
Gary

------------------------------------------
Alternative #1: Direct Assignment

PROCEDURE dbo.Vendor_UpdateVendorInfo(
@vendorId UniqueIdentifier,
@vendorName as varchar(255),
@vendorPhone as varcahr(255)

)
AS
insert vendor_info (vendor_id, vendor_name, vendor_phone) VALUES(@vendorId,
@vendorName, @vendorPhone)

------------------------------------------
Alternative #2 : The vendor Id is passed in as a uniqueidentifier. We
retrieve the vendor id form the vendor table again, ensuring that it IS a
valid data type and format.

PROCEDURE dbo.Vendor_UpdateVendorInfo(
@vendorId UniqueIdentifier,
@vendorName as varchar(255),
@vendorPhone as varcahr(255)

)
AS
DECLARE @guidVendorId as UniqueIdentifier
SELECT @guidVendorId = vendor_id FROM vendor WHERE vendor_id = @vendorId

insert vendor_info (vendor_id, vendor_name, vendor_phone)
VALUES(@guidVendorId, @vendorName, @vendorPhone)

---------------------------------------------
Alternative #3 : Pass the vendorId in as a string and CAST it as a
uniqueidentifier

PROCEDURE dbo.Vendor_UpdateVendorInfo(
@vendorId as varchar(50),
@vendorName as varchar(255),
@vendorPhone as varcahr(255)

)
AS
DECLARE @guidVendorId as UniqueIdentifier
SET @guidVendorId = CAST(@vendorId as UniqueIdentifier)

insert vendor_info (vendor_id, vendor_name, vendor_phone)
VALUES(@guidVendorId, @vendorName, @vendorPhone)