Overview of Upgrade Advisor Utility

Microsoft SQL Server 2005 Upgrade Advisor is a tool you can use to prepare for upgrades to SQL Server 2005. Upgrade Advisor analyzes installed SQL Server 2000 or SQL Server 7.0 components, and then generates a report that identifies issues that you must or should address to before or after upgrading to SQL Server 2005.

Continue reading “Overview of Upgrade Advisor Utility”

Moving System Databases — SQL Server 2000

Introduction:

There are lots of articles, Links and sites that describe how to move system databases from the SQL default location to the location described by the DBA but still lot of users find difficult while moving them and land up in trouble. So I thought that I would just do a graphical way of moving the databases so that the users can use the same and enjoy the task.

Continue reading “Moving System Databases — SQL Server 2000”