Considerations for Installing SQL Server Management Tools
SQL Server Management tools include the following components:
SQL Server Management Studio
SQL Server Profiler
SQL Server Database Tuning Advisor
Command prompt tools, such as sqlcmd.exe and osql.exe.
Business Intelligence Development Studio add-ins to Microsoft Visual Studio
Note that Business Intelligence Development Studio is a separate option during SQL Server installation.
Regardless of how many instances of SQL Server, Analysis Services, or Reporting Services are installed on a computer, only one copy of SQL Server 2008 Management Tools will be installed.
SQL Server 2008 Management Tools can run side-by-side on the same computer with earlier versions of SQL Server Management Tools.