I know that this feature is apart of Windows Vista's power management. I have tested it before and it does work well. The problem for me is that after I plugged in my Xenarc screen, it brings the computer out of standby
I am not sure about, or have seen SD do this however. CF does not have this feature that I know of. My guess is that an application like CF or SD would depend on the power management features of the OS to preform this function.