Couple of days back I have wrote an article on common issues we face while upgrading, and two methods to follow while upgrading SQL Server, this article also gives you some basic steps we need to follow post upgrades. Here is an excerpts of the article:
Upgrading the SQL Server version can have a major impact the applications using the databses. For example, from SQL Server 2005 onwards you are required to use col IS NULL instead of Col = NULL and so any applications using the later will break. Using Upgrade Advisor for SQL Server is a good start for any SQL Server however we still need to address the entire process of upgrading SQL Server to a new version. So What is the process we should follow while upgrading SQL Server? Read full story....
-- Hemantgiri S. Goswami | www.sql-server-citation.com
