[急]Delphi怎样用代码来控制SQL Server的服务启动与关闭 各位: 如题!还望各位不吝赐教! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 win2000下WinExec('net start MSSQLSERVER', SW_HIDE);WinExec('net stop MSSQLSERVER', SW_HIDE); win98下没试过 program Project1;uses Windows, WinSvc;procedure RunMSSQLSERVICE; var SrvHandle: SC_HANDLE; Service_Status: _SERVICE_STATUS; SrvStatus : Integer; begin try SrvHandle := OpenSCManager('', SERVICES_ACTIVE_DATABASE, SC_MANAGER_ALL_ACCESS); SrvHandle := OpenService(SrvHandle, PChar('MSSQLServer'), SERVICE_QUERY_STATUS or SERVICE_START); if QueryServiceStatus(SrvHandle, Service_Status) then begin SrvStatus := Service_Status.dwCurrentState; if SrvStatus = SERVICE_STOPPED then begin Winexec('scm -action 1 -slient 1 -service mssqlserver ',sw_Normal); end; end; except end; end;begin RunMSSQLSERVICE;end. 实在看不明白!Winexec('scm -action 1 -slient 1 -service mssqlserver ',sw_Normal);能启动,但是在暂停的时候就不好用了我手动设置暂停,用此命令则无法启动服务 有什么工具可以查看API函数参数的常量值和相关含义的? IdTcpClient的一个问题,以前好好的,今天就出问题了,不知道为什么 关于ADO的一个问题? 装载图片错误,请指教! xmldocument能不能删除节点? 快过年了,年终奖大调查! 在DLL中怎样退回字符串类型啊? 怎么把SELECT的内容显示在EDIT里面? 有空进来坐坐 关于TNMMSGServ和TNMMSG的问题... 动态建立BDE连接,怎么不对? TObject如何进行保存和读取
WinExec('net start MSSQLSERVER', SW_HIDE);
WinExec('net stop MSSQLSERVER', SW_HIDE);
win98下
没试过
Windows,
WinSvc;procedure RunMSSQLSERVICE;
var
SrvHandle: SC_HANDLE;
Service_Status: _SERVICE_STATUS;
SrvStatus : Integer;
begin
try
SrvHandle := OpenSCManager('', SERVICES_ACTIVE_DATABASE, SC_MANAGER_ALL_ACCESS);
SrvHandle := OpenService(SrvHandle, PChar('MSSQLServer'), SERVICE_QUERY_STATUS or SERVICE_START);
if QueryServiceStatus(SrvHandle, Service_Status)
then
begin
SrvStatus := Service_Status.dwCurrentState;
if SrvStatus = SERVICE_STOPPED
then
begin
Winexec('scm -action 1 -slient 1 -service mssqlserver ',sw_Normal);
end;
end;
except
end;
end;
begin
RunMSSQLSERVICE;
end.
Winexec('scm -action 1 -slient 1 -service mssqlserver ',sw_Normal);
能启动,但是在暂停的时候就不好用了
我手动设置暂停,用此命令则无法启动服务