MS SQL Server Concepts and Programming Question:
Download Questions PDF

How do you know if SQL Server is running on your local system?

Answer:

After installing SQL Server 2006 Express Edition, it will be running on your local system quietly as a background process.

If you want to see this process is running, run Windows Task Manager. You should see a process called sqlservr.exe running in the process list:

sqlservr.exe 00 1,316 K

If you select sqlservr.exe and click the "End Process" button, SQL Server will be stopped.

If you can not find sqlservr.exe in the process list, you know that your SQL Server is running.

Download MS SQL Server Interview Questions And Answers PDF

Previous QuestionNext Question
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS)?How to connect SQL Server Management Studio Express to SQL Server 2005 Express?