RE: Restart MSSQL Service

2014-02-26 Thread Dave Crozier
February 2014 17:52 To: ProFox Email List Subject: Re: Restart MSSQL Service On Tue, Feb 25, 2014 at 11:19 AM, Laurie Alvey truk...@btinternet.comwrote: Anyone know how programatically start/stop/restart the MSSQLServer service? (I can obviously do it via Control Panel but I want to be able

Re: Restart MSSQL Service

2014-02-26 Thread Laurie Alvey
Yes, I have Powershell but I've never used it. I'll give it a go. Thanks to all. Laurie From: Stephen Russell srussell...@gmail.com To: ProFox Email List profox@leafe.com Sent: Tuesday, 25 February 2014, 17:51 Subject: Re: Restart MSSQL Service On Tue, Feb

Re: Restart MSSQL Service

2014-02-26 Thread Gianni Turri
Hi Laurie, I use those commands in two batch files: start SQL Server.bat net start SQL Server (SQLEXPRESS) net start SQL Server Browser stop SQL Server.bat net stop SQL Server Browser net stop SQL Server (SQLEXPRESS) Then you can launch them programmatically. Change the service names to

RE: Restart MSSQL Service

2014-02-26 Thread Dave Crozier
..oops, misread the Start Programatically... statement... DOH! Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 26 February 2014 08:57 To: ProFox Email List Subject: RE: Restart MSSQL Service You should have the SQL Server

Re: Restart MSSQL Service

2014-02-26 Thread Laurie Alvey
Thanks very much - just what I wanted. Laurie From: Gianni Turri gianni...@gmail.com To: profox@leafe.com Sent: Wednesday, 26 February 2014, 10:54 Subject: Re: Restart MSSQL Service Hi Laurie, I use those commands in two batch files: start SQL Server.bat

RE: Restart MSSQL Service

2014-02-26 Thread Tracy Pearson
Laurie Alvey wrote on 2014-02-26: Thanks very much - just what I wanted. Laurie Regarding this thread. A while back I wrote a Windows Service in C# that hosted a VFP COM object. I needed the end user to start and stop the service easily. I've uploaded a prg, Ed just let me know it's

Re: Restart MSSQL Service

2014-02-26 Thread Stephen Russell
On Wed, Feb 26, 2014 at 12:24 PM, Tracy Pearson tr...@powerchurch.comwrote: Laurie Alvey wrote on 2014-02-26: Thanks very much - just what I wanted. Laurie Regarding this thread. A while back I wrote a Windows Service in C# that hosted a VFP COM object. I needed the end user to

Restart MSSQL Service

2014-02-25 Thread Laurie Alvey
Anyone know how programatically start/stop/restart the MSSQLServer service? (I can obviously do it via Control Panel but I want to be able to do it without going through Administrative Tools - Services.) I'm on  XP Pro SP3 TIA Laurie --- StripMime Report -- processed MIME parts ---

Re: Restart MSSQL Service

2014-02-25 Thread Tracy Pearson
On February 25, 2014 12:19:07 PM EST, Laurie Alvey truk...@btinternet.com wrote: Anyone know how programatically start/stop/restart the MSSQLServer service? (I can obviously do it via Control Panel but I want to be able to do it without going through Administrative Tools - Services.) I'm on  

Re: Restart MSSQL Service

2014-02-25 Thread Stephen Russell
On Tue, Feb 25, 2014 at 11:19 AM, Laurie Alvey truk...@btinternet.comwrote: Anyone know how programatically start/stop/restart the MSSQLServer service? (I can obviously do it via Control Panel but I want to be able to do it without going through Administrative Tools - Services.) I'm on XP