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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 FILESTREAM

Author  Topic 

kiranmurali
Yak Posting Veteran

55 Posts

Posted - 2011-03-29 : 08:06:45
when am updating or deleting a record which is a filestream, it is throwing error "String or binary data would be truncated".

I wanted know whether we can update or delete a record with datatype
filestream.


Thanks in Advance
Kiranmayee

DaleTurley
Yak Posting Veteran

76 Posts

Posted - 2011-03-29 : 11:30:05
That message normally means the data being inserted is longer than the column is defined as. Check the column sizes of CHAR, VARCHAR and VARBINARY columns.
Go to Top of Page
   

- Advertisement -