MS SQL Basics Tutorial: Invoking SQL Server Tools and wizards

Other SQL Server tools, such as SQL Server Query Analyzer, SQL Server Profiler (tracker), and so on, can be easily invoked in Enterprise Manager, and you only need to select the appropriate tool from the Tools menu.

SQL Server 2000 provides a number of wizard tools to guide users through a range of database and server management tasks. You can choose the Wizards option from the Tools menu, or select the icon from the toolbar to appear in the Select Wizard dialog box shown in Figure 5-17. From the SQL Server Wizard that you want to invoke, a dialog box similar to the Server Registration Wizard appears, and is simple to operate.

In addition, SQL Server 2000 improves the taskpad, adding a wizard plate to make the wizard's calls simpler and more intuitive. The way to invoke the taskpad is to select a database in the Databases group under a server in the tree window, and then select the Taskpad (taskpad) option in the View menu. Then select the "Wizards" page in the taskpad window to see the interface shown in Figure 5-18. From which you can select the wizard you want to invoke.

See the full set of "MS SQL Basics Tutorials"