The majority of professional studios use Apple Computers Loaded With Pro-Tools. This is DAW (Digiatal Audio Workstation) is also the most expensize out there. The limiations of this sofware is that it will only work with pro-tools hard ware which is also very pricey.
The software alot of studios use instead is Digital Perfomer (DP) made by Motu (Mark of the Unicorn).
Along with this software there are ton of fun, productive apps that can be used to enhance your studio.
Propellerheads inc. Make a product called Reason. Reason is a midi controlled sequencer for live and studio.
So a list of thing that I use are.
Pro Tools
Digital Performer (MAC)
Steinberg Cubase SX (PC and MAC)
Propellerheads Reason (Mac and PC)
Waves Plugins (Compression, Reverbs etc…)
Native Instrument Kontakt (Sampler Software)
Theres also a ton plugins.
Check out this website and get their free magazine.
http://www.tapeop.com/