Where is Service Manager in SQL Server 2005?

Hot Topic

Migrate Access 2002 to SQL Express 2005
Error evaluating expression
Debugging SP On server from workstation using Query Analyzer
Bulk Insert
small question
What exactly can sp_executesql parametrize?
Replication and direct updating in SQL 2000
how do i get date into dd-mm-yy format??
Replication and direct updating in SQL 2000
Reading from a XML Source

SQL Server

Custom assembly : Retrieving data from from configuration file.
Package Configurations not so portable?
Study Material
How do you support the Oracle CLOB Data Type?
SQLExpress on a dual core processor
Auto-partitioning
Maximum number of partitions in AS2005
About the sql 2005 client software
Using Oracle Stored Procedure
Security Question

Where is Service Manager in SQL Server 2005?

I installed SQL Server 2005 CPT on a new machine running XP.  I do not see SQL Server Service Manager.  Has something changed in 2005 over 2000   There are times when it is necessary to stop the database.  The old way you just clicked on the icon in the lower right of the PC (with the green arrow) and selected stop. 

I realize I can go into XP Services, find SQLServer2005, right click and select stop, but is there some simpler way, like with an icon,  like there used to be

I know this is an elemental question but I am an elemental user <g>

Answer this question

Where is Service Manager in SQL Server 2005?

  • sigrun

    Well, that's part of the point.  I do not see Computer Manager after installing SQL Server 2005 CPT.  I thought maybe it was a matter of it not getting installed by default, so I went back and looked at the options in Custom Install.  I did not see a reference to it there either.

    It would be nice to be able to stop a database with as few key strokes as possible.  It would also be nice to be able to do this in some sort of a batch file; e.g., one I could run just before doing a copy of files and directories.

  • DaManJ

    Euan is right. With the SQL Computer Manager, you can start, stop, pause your SQL Server servcies.  Open SQL Computer Manager, then under SQL Server 2005 Services, simply selct the corresponding service you want to start/stop/pause and do your stuff just like in any MMC admin console. 

  • cooknfamily

    Start|Programs|Microsoft SQL Server 2005|Configuration Tools or go to Computer Manager and Expand Services and Applications, it should appear as a node there.

    To do this in a batch file you can use WMI Service Management or SMO.

  • MohsinAta

    By either method that you mentioned it is not possbile to drag and drop a copy onto the desktop or to the toolbar at the bottom of windows.

  • mmengel

    This was removed earlier in the release process, the pay to do this today would be to have shortcut to SQL Computer Manager on your desktop/taskbar.

  • nick child

    you can create a shortcut to sql computer manager on the desktop or on your quicklaunch bar, same is true of a bat/cmd file

  • Where is Service Manager in SQL Server 2005?
Answer this question