May 8, 2014 at 3:38 am
So I managed to create a database and a table with one filestream column. And I even managed to fill it using MS Access as a front-end. However I'm gonna need more than one filestream column. And some how this doesn't seem to work....
CREATE TABLE [dbo].[Items3](
[ItemID] [uniqueidentifier] ROWGUIDCOL NOT NULL,
[ItemNumber] [varchar](20) NULL,
[ItemDescription] [varchar](50) NULL,
[ItemImage] [varbinary](max) FILESTREAM NULL,
[ItemImage2] [varbinary](max) FILESTREAM NULL,
UNIQUE NONCLUSTERED
(
[ItemID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] FILESTREAM_ON [NorthPoleFS]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[Items3] ADD CONSTRAINT [DF_Items_ItemID2] DEFAULT (newid()) FOR [ItemID]
GO
It managed to execute, and it worked perfectly fine as well with one column. But as soon as i tried to fill both with a different image it fails. Errror message saying "....image pointer value conflicts with the column name specified...". I do sort of understand why it fails, but I just don't know how to solve it....
So what am I doing wrong?
May 11, 2014 at 6:32 am
Never mind, I'll post a reply myself:
http://www.mssqltips.com/tipcomments.asp?tip=1489, Comments and Feedback section
Looks like it is not an issue in 2012 (I tested it, 6 columns: works).
Not sure though if it will work in 2008.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply