In connection with this question, I downloaded a Hex Editor to see just what values my SDF file contained in a certain location, which is supposed to tell me what version of SQL Server CE the SDF file was created with.
I got the following info:
SQLCE Version
2.0: 0x73616261
3.0: 0x002dd714
3.5: 0x00357b9d
4.0: 0x003d0900
...from this page. But I don't know what I'm looking at; I don't know if I'm looking in the wrong column or row, and I know that once I do know where I need to be looking, that data has to be converted to correspond with what is shown in the chart above.
Can somebody tell me how to decipher this raw data, and which column and row I should be focused on?
Here is what I see with one (older) file loaded:
...and here is what I see with a newer one:
If I select Search > Goto..., set Offset to 16, hex format, and from the beginning:
...it takes me just before the second "20" on row two. By choosing "Decimal" it takes me to the beginning of the second row; I reckon that's correct.
The data is stored little-endian. Both show 0x73616261, meaning both are SQL CE version 2.0 database files.