• By default Management Studio will be installed as part of SQL 2005 installation. SSMS is a one tool which can be used to perform all sql server related activities like administration,querying. In simple words the SSMS performs both the operation of EM & QA which was in SQL 2000.

    For Migration from 2000 to 2005, follow the conventioinal and adviced method given by microsoft.