Restart the sqlserver service and computer through sqlserver

/*
Restart the sqlserver service and require the operator to have the relevant permissions.

-- Vivianfdlpw 2005.9 reference please keep this information
*/

-- Create a restart script
Declare @ o int, @ F int, @ t int, @ RET int
Exec sp_oacreate 'scripting. FileSystemObject ', @ o out
Exec sp_oamethod @ o, 'createtextfile', @ F out, 'c:/restart. bat', 1
Exec @ ret = sp_oamethod @ F, 'writeline ', null, 'net stop MSSQLServer'
Exec @ ret = sp_oamethod @ F, 'writeline ', null, 'net start MSSQLServer'

-- Execute the restart script
Exec master .. xp_mongoshell 'C:/restart. bat'

/*
If you restart the computer, make sure that the MSSQLServer account runs under the Administrator account (non-local SYSTEM account)

-- Vivianfdlpw 2005.9 reference please keep this information
*/

Exec master .. xp_mongoshell 'shutdown/R/F'