sql server msde: Hi all
How can I start SqlServerServiceManager for a special instane name
programaticaly??

thanks

hi,
[quoted text, click to view]

you probably have to start a specif innstance of SQL Server service, and you
can do it programmatically as long as the Windows account you are logged as,
has appropriated permissions..
you can do that using the SQL-DMO object model, via the .Start method of the
SQLDMOSqlServer referenced object pointing to the relative instance,
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_m_s_7vg2.asp,
or using the Service Control Manager (SCM utility) and even via local "NET
START serviceName" command shell commands... have a look at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_start_5qih.asp
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
--------- remove DMO to reply

Weel that depends on your coding language. For .NET you can use the
ServiceControlManager (SCM). Other options would be to use the common
method (like calling a commandline statement), see more information
about that on my site in the screencast section.

HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---