An SqlParameter with ParameterDirection.Output has default size of 1 , this can be tricky if you use command.Parameters.AddWithValue(parameter, value) method in .NET 2.0. It was caught on my unit test when I want to retrieve the value of an output parameter, the returnErrorMessage variable must contain...