Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2006-01-20 : 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 1Location: record.cpp:2429Expression: m_futureSize == 0 || rec.Size () == m_futureSizeSPID: 58Process ID: 1472Connection BrokenThe 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 OSAnd if it's impossible to insert data in such a way how can I solve this problem.Thanks." |
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
|
|
|
|