Handling the error would be done in code.
For e.g.
private bool ChangeUserPassword()
{
try
{
List paramList = new List()
{
new SqlParameter()
{
ParameterName = "@GUID",
Value = Request.QueryString["uid"]
},
new SqlParameter()
{
ParameterName = "@Password",
Value = FormsAuthentication.HashPasswordForStoringInConfigFile(txtNewPassword.Text, "SHA1")
}
};
return ExecuteSP("spChangePassword", paramList);
}
catch (SqlException sqlEx)
{
}
catch (Exception ex)
{
}
}
The next part would be how fix this exception.
Looks like you are trying to insert a string longer than the field length in the database.
This could be throwing the exception.