attach_db.cmd

@echo off
rem ###################################
rem
rem 產生自動掛載 SQL
rem
rem ###################################
setlocal

rem 變數
set _DB_PATH_=d:\SQL_DATA
set _OUT_SQL_=attach_dbs.sql

:MAIN
cls
rem 產出 檔頭
echo /*>%_OUT_SQL_%
echo. 自動掛載 SQL>> %_OUT_SQL_%
echo */>>%_OUT_SQL_%

rem 產出 Attach Script
for %%A in (%_DB_PATH_%\*.mdf) do (
    echo 處理資料庫 %_DB_NAME_% ...
    echo.>> %_OUT_SQL_%
    echo -- %%~nA (PRIMARY) -->> %_OUT_SQL_%
    echo EXEC sp_attach_db @dbname = '%%~nA'>> %_OUT_SQL_%
    echo   ,@filename1 = '%%~dpnxA'>> %_OUT_SQL_%
    echo   ,@filename2 = '%%~dpnA_log.ldf'>> %_OUT_SQL_%
)
rem 印出 Script
type %_OUT_SQL_%

endlocal