SQL SERVER Service Programmatically Startup

[smoothcoder]

Hi there,
does anyone know how could I programmatically start SQL SERVER Service from VC++ (MFC)

(I write a custom MSDE Setup application and I want to start the service once the setup completes)

Thanks in advance!

 

[fluteplr]

From Books Online

Command prompt

Start an instance of SQL Server or the SQL Server Agent service from a command prompt by typing:
net start mssqlserver or sqlservr, or net start SQLServerAgent or by running SQLSERVR.EXE. If you are referring to a named instance of SQL Server, you must specify mssql$instancename or SQLAgent$instancename.

There are several other methods available. I would suggent you look at BOL.

 

[SpiderBear6]

You can use the sqldmo.dll.

--------------------------------------
"We are star-stuff. We are the universe made manifest trying to figure itself out."
-- Delenn in Babylon 5 - "A Distant Star"