.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

Start/Stop Sql services

Posted By: Aamrapali Tamgadge     Posted Date: October 24, 2011    Points:5   Category :Sql Server
Hello,friends..i knw the way to start or stop the sql services fromconfiguration manager.

but how can i check programaticaly whether the sql server services are stopped or running in dot net.

Responses
Author: Narayanan             
Posted Date: October 24, 2011     Points: 20   

Hi,
try this link
http://www.eggheadcafe.com/community/csharp/2/10146464/restart-sqlserver.aspx

Regards, Lakshmi Naraayanan.S
http://dotnettechrocks.blogspot.in/
Author: Amit Mehra             
Posted Date: October 27, 2011     Points: 20   

Hi,

SQL Server services name is SQLServerAgent

You can user ServiceController class to check the services is running or not..let me now if you need the code

Thanks,
Amit
Please "Mark As Answer " if this post help you.
Author: sriram             
Posted Date: October 27, 2011     Points: 20   


Go to services-->select sql serverAgent-->stop and start-->

pls let me know u r requirement for programmaticaly stop and start services in sql server..


Regards
Sriram.R

www.databaseresource.blogspot.com

Author: Ravi Ranjan Kumar             
Posted Date: October 29, 2011     Points: 20   

Try
a nice article for using the ServiceController in C# to stop and start a service.
http://www.codeproject.com/KB/system/Svc_Controller_in_C_Sharp.aspx

Thanks & Regards
Ravi Ranjan Kumar
http://raviranjankr.wordpress.com
Author: williams             
Posted Date: October 31, 2011     Points: 20   

hi,

what is the main use of using the sql server 2005 instead of ms access or any other backends.
is it possible to install the windows application packaged setup without installing sql?

website development firm in coimbatore
___________________________________________

website development firm





Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend