The behind the scenes optimizations that are out with SQL Server 2008 as well as the enhansements to SSIS, SSAS, SSRS development and T-SQL enhancements make it a no brainer to me. The development time saved is totally worth the investment! Testing and validating is also much quicker. If I want to test a bug in a procedure and need to create a working copy for debuging, I bring over the input variables add one simple declare, the guts of the procedure minus try catch blocks and begin debugging. Now, I do not have intellisense, I do not have the ability to add most of a procedure with only one or 2 lines. Now I have to declare every input variable and set every input variable instead of only changing the defaults on just one or 2 for testing. I have a SQL 2005 environment and a local environment of 2008 for debugging, my PM wants to know how I can find problems so quickly when others can't even get their working copy by the time I am finished. I am sorry, but I just think that with lots of complex mathmatical t-sql in my industry, it is far to much of a no brainer.

I also do not have to jump through hoops trying to build things in SSRS that are simply not available with SQL Server 2005.

All of that being said, THIS IS A FORUM, and everyone is entitled to their opinion. This is just mine and intended in no way to be offensive, derogatory, or pointed at anyone.

BE KEWL!