SQL sp_OAMethod String Length Return Value Limitations

The sp_OAMethod function is used to call ActiveX methods in SQL stored procedures.  If the ActiveX method returns a string, there is a limit imposed by sp_OAMethod on the size of the string that can be returned.  (Perhaps it is 4000 chars?) This blog post describes a way to workaround this limitation. An example of a method call that is […]