I'm trying to modify an SP using Vb code. The SP is rather extensive because it uses a lot of Else If statements. I keep getting errors when I run the Execute statement to create the SP and I think its because I'm sending too large of a string. My ADO looks something like this:
cmd.CommandType = adCmdText
cmd.ActiveConnection = cn
cmd.CommandText = str
The length of the variable str is >33000
The length doesn't seem to be a problem when the sp is created manually using either SQL Query analyzer or Access ADP.
How can I create a large SP in VB?