• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 751
  • Last Modified:

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.
0
mammouth
Asked:
mammouth
1 Solution
 
Guy Hengel [angelIII / a3]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

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

Tackle projects and never again get stuck behind a technical roadblock.
Join Now