Popular Posts

  • Retrieving the data posted to a JSP file from HTML file
    Now I will show you how to retrieve the data posted from a HTML file in a JSP page. Consider an html page that prompts the user to enter his...
  • Accessing the Standard CGI Variables
    Accessing the Standard CGI Variables: To build the successful web application, you often need to know a lot about the environment in which ...
  • INTRODUCTION TO C
    INTRODUCTION TO 'C': C is a programming language developed at AT & T's Bell laboratories of USA in 1972.it was designed by d...
  • SQL ALIASES
    SQL aliases can be used with database tables and with database table columns, depending on task you are performing. SQL column aliases are u...
  • Learning about Events (Continue)
    Learning about Events (Continue) Lets program the Form_Load event. "MsgBox" is Visual Basic command that launch a message box. for...
  • Exercise 11.3: Polymorphism
    Steps to follow: 1. Write Person.java as shown below in Code-11.3.a under polypackage directory. (You are welcome to do this work using eit...
  • The Command Button's KeyPress, KeyDown and KeyUp Events
    The Command Button's KeyPress, KeyDown and KeyUp Events The events that will be mentioned in the following pages are commonly used, and ...
  • SQL AVG
    The SQL AVG aggregate function selects the average value for certain table column. Have a look at the SQL AVG syntax: SELECT AVG(Column1) FR...
  • INTERFACES EXAMPLES
    package interfaceexercise; // Define an interface with three abstract methods. // Any class that implements this interface has to // impleme...
  • SQL LIKE
    We will use the Customers table to illustrate the SQL LIKE clause usage: FirstName LastName Email DOB Phone John Smith John.Smith@yaho...

Wednesday, March 18, 2009

How to start and stop SQL Server service ?

A "service" is an application that can start automatically when the computer starts.

There are two start up modes:

1. Automatic - the service starts automatically when the computer starts.
2. Manual - the service is installed, but will not start until somebody manually start it.

By default, SQL Server is configured as "Automatic". So, SQL Server service starts when you start your computer. However, some developers will change it to "Manual" mode for various reasons. One example is, if you have a very slow computer, you may want to stop all unwanted applications running. So, you can go and stop the SQL Server service. Also, you can change it to "manual" mode so that it won't start automatically everytime you reboot your computer. However, when you want to run an application that need to access SQL Server, you have to go to the service control manager and start the service.

Service Control manager

"Service control manager" is a windows tool that allow you manage all services (including SQL Server service) installed on the computer.

To open the service control manager, go to Control Panel -> Administrative Tools -> Services.



You can see the list of all installed services and their current status. Right click on any service name and see the context menu. You can see various options like Start, stop, restart, pause etc.

The above image shows several service names starting with the word "SQL Server...". They are various services related to SQL Server. You can right click on the service name and select any task like Start or Stop.
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)