|
AskSQLTeam
Ask SQLTeam Question
USA
0 Posts |
 Posted - 01/20/2006 : 08:40:24
|
Andrew writes "While executing such a query:
INSERT INTO UserImages(UserID,ImageData)
select 823,Thumbnailphoto from openquery(ADSI,'SELECT Thumbnailphoto FROM ''LDAP://company.com'' WHERE objectCategory = ''Person'' AND objectClass = ''user'' AND mail = ''Smith@company.com''')
I'm getting such an error.
Server: Msg 3624, Level 20, State 1, Line 1
Location: record.cpp:2429
Expression: m_futureSize == 0 || rec.Size () == m_futureSize
SPID: 58
Process ID: 1472
Connection Broken
The problem is in inserting data(it's DATALENGTH is 36918 bytes) into the table IMAGE column, not selecting it as the select statement works fine.
I'm using MSSQL Server 2000 + SP4 and I've got two instances)(default and named(Used by SharePoint Portal)).
Windows 2003 Server OS
And if it's impossible to insert data in such a way how can I solve this problem.
Thanks." |
|
Error inserting IMAGE data column
Forum Locked
