Suppressing the removal of leading zeros in numeric data
Retaining leading zeros for numeric data types is not possible.  Since you appear to be using this column as a non-numeric identifier, you should consider using a varchar column of appropriate length.

If the maximum length you're willing to accept in the table is 11 characters, and the value is always required, I would define the column like this:

someCol varchar(11) NOT NULL


The column will then differentiate between 08 and 000008, and the leading zeros will be retained.