
CODE: [Copy to clipboard]停止net start MSSQLSERVER
CODE: [Copy to clipboard]net stop MSSQLSERVER

CODE: [Copy to clipboard]@echo off
for /f "tokens=4 delims= " %%a in ('sc query MSSQLSERVER^|findstr "STATE"') do (
if "%%a" neq "RUNNING" (
echo 数据库服务器未开
) else (
echo 数据库服务器开啦
)
)
CODE: [Copy to clipboard]:attachdb
osql -U"%dbloginname%" -P"%dbloginpwd%" -S"127.0.0.1" -Q"sp_attach_db '%dbname%','%SQL%\%dbmdf%','%SQL%\%dbldf%'" 2>nul
if %errorlevel% neq 0 (
echo 数据库服务器未开
goto :exit
)
| 欢迎光临 中国DOS联盟论坛 (http://cndos.fam.cx/forum/) | Powered by Discuz! 2.5 |