Upgrading a SQL Server database should be straight-forward, when you haven't got much of constraints on the application code. In this regard we have blogged previously such as UpgrageTags posts. Here in this post I would like to go with few FAQs that are related to Upgrade process & procedure: Say you need to manage SQL Server 2000 version intances with a single SQL Server and if you are willing to upgrade tools on that central-monitoring server then better to go within such process, as you can...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/tools/archive/2008/01/22/upgrade-blurg.aspx