Ask SQLTeam Question
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
Expression: m_futureSize == 0 || rec.Size () == m_futureSize
Process ID: 1472
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.