SQL Server Tools

SQL Query Analyzer and the osql utility support using Transact-SQL interactively to access and change data, and the bcp utility can be used to insert large numbers of new rows into a table quickly. SQL Server Enterprise Manager is used to administer multiple instances of SQL Server from a single console.

SQL Query Analyzer and osql are used to:

• Execute one or more Transact-SQL statements.
  
  
• Either display the results of a query to the user, or save the results in a text file.

Using SQL Query Analyzer, you can connect simultaneously to multiple instances of SQL Server Enterprise Manager. SQL Server Enterprise Manager also supports working with multiple instances of SQL Server at the same time. The osql and bcp utilities only support working with one instance at a time.