Max length sp_OASetProperty

what is the max length string i can pass to sp_OASetProperty, i try to pass a 8000 msg long, but is truncated.

My string contain 'abc...xyzbc...xy...', no special char in it.
LVL 1
mammouthAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
Fact is that the limit for the newvalue parameter is 255 in SQL 7, as newvalue is of type varchar.
This doesn't seem to have changed since...

CHeers
0
 
mammouthAuthor Commented:
Yes the newvalue is varchar, but if i pass my varchar(8000), the last 2000 will bu truncated.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.