So in order for this to happen you have to :-
a) have done an upgrade instead of a clean install
b) had the guest account enabled prior to the upgrade
c) have automatic login enabled.
interestingly, the 10.6 disk is not an upgrade version, it's actually the full version and no previous version is needed. Not bad for £25