Sound will get stripped/will not exist. DVI does not carry sound because the port does not support it, not because the cable does not support it!
This is partially incorrect. Newer video cards (Nvidia 4xx or higher, and not sure on the ATI side) output Audio via their DVI connecters when used in conjunciton with an HDMI to DVI cable, or adapter. DVI used alone does not include audio.