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.