SPS Home    >   Dgreath    >   RDBMS    >   Tools

TOOLS

SQL server tools can be installed on either the server itself or on a client machine. The client machine must have network connectivity with the server and  the user must be able to authenticate in that domain. In order to use these tools, each needs to be connected to the desired server.
Query Analyzer:
This tool is located in the Microsoft SQL Server tab under the Programs tab. It is the primary means to create, read, and write to SQL databases.
Enterprise Manager:
This tool is located in the Microsoft SQL Server tab under the Programs tab. It is the primary administration tool for SQL Server.
ODBC Data Source Manager:
This tool is located in the Administrative Tools of the client machine. It allows the creation of a logical connection from that machine to SQL Server databases. Configure the File DSN tab for the SQL Server driver, the desired server to attach to, the desired .mdf file on that server, and assign a connection name. The connection name need not be the same as as the database name and is what local queries will refer to. In addition, appropriate credentials may need to be furnished.
Profiler
This tool is located in the Administrative Tools of the client machine. It provides a means to trace the server's performance by capturing selected events in and out of the server. 
Service Manager
This tool is located in the Administrative Tools of the client machine. It provides a means to start, pause, and stop any SQL Server in the domain.