MAXCHARLENGTH in SQL SMO

Question

MAXCHARLENGTH in SQL SMO

gwellbrock

Ten Centuries

Points: 1130
More actions
April 5, 2017 at 6:44 am

#329109

I export blob data using invoke SQL with the parameters -MaxCharLength and -MaxBinaryLength so that it doesn't get off. How do I do the equivalent in SMO?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Gary Varga SSC Guru Points: 82166 More actions · Answer 1

Unless I am mistaken, you can sill use the same parameters. See: https://blogs.technet.microsoft.com/heyscriptingguy/2013/05/06/10-tips-for-the-sql-server-powershell-scripter/

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!

Gary Varga SSC Guru Points: 82166 More actions · Answer 2

Any luck? If so please let us know. Did I give the correct info? If so then please mark mine as the answer. If not then please add your own and mark it as the answer. That will help the next person after the same resolution. Thanks!!!

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!

gwellbrock Ten Centuries Points: 1130 More actions · Answer 3

I just changed my code to invokeSQL 🙁 I'll test it out on my local and get back to you later this week early next.