/
AstroJohn
/
MailRobot
Обзор
Документация
Войти
/
AstroJohn
/
MailRobot
Код
Запросы
0
Задачи
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
DBProject/UpdateScripts/runsqlcmd.cmd
26 строк
878 B
AstroJohn
FD-VHF
05 авг 2026, 19:56
05 авг 2026, 19:56
637c2cb
Код
Авторство
О чём код?
rem @echo off set sqlscriptpath="c:\SQLData\MSSQL12.MSSQLSERVER\MSSQL\Scripts\Script001.sql" set sqllogpath="c:\Temp\runsql.log" set sqlbackupcommand="exec MakeBackupNew" set dbnamesquery="set nocount on;select name from sys.databases where name not Like 'master' and name not Like 'tempdb' and name not Like 'model' and name not Like 'msdb' order by name" rem set sqlserver="RK1AA-MODERN\SQLEXPRESS2014" rem set sqllogin="sa" rem set sqlpwd="kb2wkd" set sqlserver="alrs.astrojohn.ru" set sqllogin="sa" set sqlpwd="r/kb2wkd" sqlcmd -S%sqlserver% -U%sqllogin% -P%sqlpwd% -Q%dbnamesquery% -h -1 > tmp.txt for /f "delims== tokens=1" %%G in (tmp.txt) do ( echo %%G rem sqlcmd -S%sqlserver% -U%sqllogin% -P%sqlpwd% -d %%G -i %sqlscriptpath% >>%sqllogpath% sqlcmd -S%sqlserver% -U%sqllogin% -P%sqlpwd% -d %%G -Q %sqlbackupcommand% >>%sqllogpath% ) del tmp.txt pause