>I have a field "ATPre" VarChar(6) in a table that, for whatever reason, is only able to store first three characters of a default value when a record is added from one of the stored procedure. I know this sounds very weird but the correct default value of "SAT/LG" is set if:
>
>1. I add a new record via Enterprise Manager table view.
>2. Execute INSERT statement directly from Query Analyzer.
>3. Call a test stored procedure that calls a simple INSERT statement.
>
>However, a simple "INSERT Production (MatrixID) VALUES (@MatrixID)" statement within one of the actual production stored procedure adds just "SAT" as the default!
>

Is @MatrixID a sp parameter ?
Is @MatrixID = 'SAT/LG' ?

Check with the SQL profiler the sp parameters.


>This is really frustrating to say the least. I've worked with MSSQL for years and never had a similar problem before. I've checked code everywhere that the default might be overriden and can't find anything. What can be the problem? TIA.