I agree that Production is always needed to keep the business running well. In SQLServer 2005 make things more complex and introuce lots new stuff which needs good expertise.
I think debugger is best tool to troubleshoot the complex stored procedure, I always encourage my developers to use and I used myself while developing some tricky sp and wouldn't...