What is the name of the Left 4 dead 2 theme song

I'm not exactly sure what you mean by "Theme Song" because there are a lot of different common songs in the game. But you can browse the videos here to find which soundtrack you're thinking of:

http://www.youtube.com/tylerburritoalt