If your code uses distributed transactions and you get the "MSDTC on server '[SERVER NAME]' is unavailable" error, all you have to do to fix it is go to the Services console on your server and start the Distributed Transaction Coordinator service.

On Vista, you can click on Start > Administrative Tools > Services to go to the Services console.

Cheers,
Raj

~~~ CODING FOR ETERNITY !!! ~~~