怎样用代码控制SQL Server的启动和关闭?(30分)

H

hhjjhhjj

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-07-07

• #1

如题:
启动好象是:运行 net start MSSQLSERVER

 

K

kite20020304

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-07-07

• #2

winexec('net start MSSQLSERVER', 0);

 

M

maze

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-07-07

• #3

winexec('net start MSSQLSERVER',sw_hide)
winexec('net stop MSSQLSERVER',sw_hide)

 

F

flyskylf

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-07-07

• #4

测试通过

 

A

ahhlian

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-07-07

• #5

winexec('net start MSSQLSERVER',sw_hide)
winexec('net stop MSSQLSERVER',sw_hide)

这两条命令可以实现sql的开启和关闭，但怎么判断sql当前的状态呢？

 

H

hhjjhhjj

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-07-08

• #6

多人接受答案了。