Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Incorrect status in services panel 1

Status
Not open for further replies.

kindus

IS-IT--Management
Jul 25, 2001
77
US
When I start sqlserver from command prompt, command window shows

" Sqlserver ready for client connection ..."

that is okey, but the command window does not come back to command prompt. If you close the window, abnormal shutdown occurs. My question will be
1) Is it not odd to keep the command window open, still you cann't use it because it is not in the command prompt???
2) In the services (control panel) it still shows sqlserver not started, where as it is started and I am using it, another odd stuff??

Can someone explain it to me, why is sqlserver/window behaving like unfinished product?

thanks
 

When you start SQL Server from a command prompt, the command window becomes the console. If SQL Server is
running you will not get a command prompt. If you do get a command prompt, then SQL Server is not running. The window will not return control to you until SQL Server is stopped. If you close the command prompt window you will stop SQL Server. SQL Server does not show as running in the services Window because it is not running as a sevice. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top