crizoo4712 wrote:

> since the password is moved to another field (2000 characters long), it
> really doesn't matter how long the default value for it is.

Wrong. The default value is assigned in the line the variable is
declared at.

> in the worst case, it's just truncated.

Wrong. You cannot assign a long string to a shorter column/variable. A
string truncation error occurs.

> and the sp crashes "long" before the reference of the password.

It crashes even if the SP body is empty. See above.

> i shortened it to 20 characters and the sp crashed again.

Nope, it doesn't crash anymore after the change.


Dmitry