We help IT Professionals succeed at work.

Simple SQL 2005 questions

Rouchie
Rouchie asked
on
I've just upgraded to 2005 from 2000, and have a few simple questions about the new user interface.  I'd be grateful for any pointers :-)

1) What happened to the system tray icon that allowed you to turn off/on the SQL Server service?  Do I have to use the Surface Area Config tool now or is there a quicker way?

2) Is it possible for SQL Management Studio to remember the current tree node from the last user session?  This was available in Enterprise Manager's options

3) When executing queries from the query editor, is there a way to hide the Results window after execution ends?  There was a button to hide this in Query Analyzer but I can't find an equivalent
Comment
Watch Question

Database Consultant
CERTIFIED EXPERT
Top Expert 2009
Commented:
>What happened to the system tray icon that allowed you to turn off/on the SQL Server service?  
SQL Server Service manager is no more available with 2005, yu can use probably make use of the services ( start->run->services.msc  )  to start / stop the service

>2) Is it possible for SQL Management Studio to remember the current tree node from the last user session?  This was available in Enterprise Manager's options
i dont think so

>3) When executing queries from the query editor, is there a way to hide the Results window after execution ends?  There was a button to hide this in Query Analyzer but I can't find an equivalent
use
 crtl + R

Explore More ContentExplore courses, solutions, and other research materials related to this topic.