Greetings,

We are in the process of purchasing SQL Server 2008 in order to upgrade
installations of SQL Server 2000. One of our applications uses a number of
stored procedures to operate.

What kind of issues are involved in doing such a conversion? We had
considered going to SQL Server 2005 first before upgrading to 2008, but since
2008 is out, would it be more advantageous just to jump all the way up to
2008 with our upgrade and bypass 2005?

I need an answer very quickly, before the grant money being asked for is
shut down.

I would go directly to 2008 and bypass 2005. You would like 2005 over
2000, but 2008 has some pretty cool features and will be supported
longer than 2005.

You could continue to run SQL SERVER 2008 in 2000's compatibility mode
as a last resort. I'm not certain about DTS packages from 2000
either. They might need to be upgraded to SSIS packages.

If you're going to make the jump, I would suggest going to 2008 at
this point.

Here's another opinion on the subject:
http://sqlblog.com/blogs/denis_gobo/...7/09/7753.aspx

-Eric Isaacs