>>>>>No. It's a result of SQLEXEC command.
>>>>
>>>>Then in the method where you add record REPLACE default values :-)
>>>
>>>How? I want to replace with the defaults from the database. In other words, looks like we need to bring the defaults for the columns in a separate statement...
>>>
>>>All sounds quite tricky, but as I examined our tables yesterday, I found that we're not using defaults.
>>
>>

>>sp_columns 'NamerOfTheTable' 
>>

>>And check Column_Def column.
>
>Can you get this info by a different method? I wanted to test every table in DB just to see if either table has defaults (I think here we're not favoring defaults).

One time job?
If so:

EXEC sp_MSForEachTable 'EXEC sp_columns ''?'''

:-))))))))))