problem to start a sql server service manager
-
hai all i am using sql server 2000. when i worked in .net,suddenly sql server service manager is stopped.then i tried to start the sql server service manager in service...it showing error as "The MS SQLSERVER service on local computer started and then stopped.some services stop automatically if they have no work to do,for example,the performance logs and alerts service."how to solve this? thanks in advance.
-
hai all i am using sql server 2000. when i worked in .net,suddenly sql server service manager is stopped.then i tried to start the sql server service manager in service...it showing error as "The MS SQLSERVER service on local computer started and then stopped.some services stop automatically if they have no work to do,for example,the performance logs and alerts service."how to solve this? thanks in advance.
-
Anything in Event log (system or application).
The need to optimize rises from a bad design. My articles[^]
i can't understand...what u say....
-
i can't understand...what u say....
If the service stops unexpectedly, open Event Viewer from control panel and check both Application log and System log. Find out if there are any error messages related to Service Manager. Or do you mean the windows application which is found in Task bar and can be started from Start menu?
The need to optimize rises from a bad design. My articles[^]