SQL Server Enterprise Manager FAQ

Troubleshooting SQL Server

Troubleshooting

SQL Server Enterprise Manager FAQ

How can I get my system databases to appear after they have been hidden from view in SQL Server Enterprise Manager?

Right-click the server icon to change the setting that shows or hides system databases and system objects. Click Edit SQL Server Registration Properties, and then on the General tab, select Show system databases and system objects.

I'm having difficulty viewing the information in the results pane of SQL Query Analyzer. What can I do?

Answer:

If there is either too little or too much text in the results pane of SQL Query Analyzer, you can display the query results in a grid. Either press CTRL+D or click Results in Grid on the Query menu and then execute the query again.

If you are still having difficulty viewing the appropriate data in the results pane, adjust the maximum number of characters per column. On the Tools menu, click Options, and then click the Results tab. In the Maximum characters per column box, enter the number of characters to display. To view more characters, set this number to 256.

Why isn't the SQL Server Service Manager icon removed from the taskbar when the Service Manager window is closed?

Answer:

The SQL Server Service Manager icon shows the status of one of the Microsoft® SQL Server™ services. Closing the SQL Server Service Manager window only removes the dialog box from view; it does not affect the icon in the taskbar. To remove the icon from the taskbar, right-click the icon, and then click Exit.

How can I administer SQL Server through SQL Server Enterprise Manager without using the mouse?

Answer:

Press SHIFT+F10 to perform a mouse right-click. For more information about keyboard shortcut keystrokes, see Using Accessibility Shortcut Keys in SQL Server Books Online.

previous page start next page