The status code contains a decimal representation of the bit mode data.

In your case, value 28 = 4 + 8 + 16

Which means all of the conditions below.

4 = select into/bulkcopy; set with sp_dboption.

8 = trunc. log on chkpt; set with sp_dboption.

16 = torn page detection, set with sp_dboption.