staring SqlServerService programmatically

24 Aug 2006 9:21 AM

perspolis

Hi all
How can I start SqlServerServiceManager for a special instane name
programaticaly??

thanks

24 Aug 2006 10:52 AM

Uri Dimant

SQL Server 2005
Take a look at sqlwb.exe file

Show quote

"perspolis" <reza***@hotmail.com> wrote in message
news:%23Lh3sh2xGHA.1788@TK2MSFTNGP05.phx.gbl...
> Hi all
> How can I start SqlServerServiceManager for a special instane name
> programaticaly??
>
> thanks
>

24 Aug 2006 9:27 PM

Hugo Kornelis

On Thu, 24 Aug 2006 13:51:49 +0430, perspolis wrote:

>Hi all
>How can I start SqlServerServiceManager for a special instane name
>programaticaly??

Hi perspolis,

Switch to the correct Binn directory for that instance, then execute the
sqlservr.exe utility wiith a -s parameter.

For instance:

cd \Program Files\Microsoft SQL Server\MSSQL.7\MSSQL\Binn
sqlservr.exe -s <computer_name>$<instancename>

--
Hugo Kornelis, SQL Server MVP

24 Aug 2006 10:27 PM

Bob Beauchemin

SQL Server Service or SQL Server Service Manager? To start the *service*
programmatically, if you have SQL Server 2005, you can use the WMI classes
in SMO. ManagedComputer and Service classes. Let me know if you need more
information on this.

Bob Beauchemin
http://www.SQLskills.com/blogs/bobb

Show quote

"perspolis" <reza***@hotmail.com> wrote in message
news:%23Lh3sh2xGHA.1788@TK2MSFTNGP05.phx.gbl...
> Hi all
> How can I start SqlServerServiceManager for a special instane name
> programaticaly??
>
> thanks
>

26 Aug 2006 5:48 AM

perspolis

thanks all
Show quote

"Bob Beauchemin" <bobb_no_spam@SQLskills.com> wrote in message
news:eXud2x8xGHA.3656@TK2MSFTNGP04.phx.gbl...
> SQL Server Service or SQL Server Service Manager? To start the *service*
> programmatically, if you have SQL Server 2005, you can use the WMI classes
> in SMO. ManagedComputer and Service classes. Let me know if you need more
> information on this.
>
> Bob Beauchemin
> http://www.SQLskills.com/blogs/bobb
>
>
> "perspolis" <reza***@hotmail.com> wrote in message
> news:%23Lh3sh2xGHA.1788@TK2MSFTNGP05.phx.gbl...
>> Hi all
>> How can I start SqlServerServiceManager for a special instane name
>> programaticaly??
>>
>> thanks
>>
>
>
>