When you create a database snapshot, the snap shot doesn’t hold any data. Each page that is modified for the first time in the original database, is copied to the snapshot with the data that it had before the modification (of course if the same page is modified again it will not be copied anymore). When you issue a select query on the snapshot, it will get the data from the snapshot itself only if the original data in the original database was modified. If the original data in the original database was not modified, it will query the table in the original database in order to get the information.

Adi