Import-Module 'sqlps' -DisableNameChecking


$SV = 'TSTSQL001\MSSQLSERVER1'
$UserID = 'sa'
$Password = 'p@ssw0rd'
$DBName = 'TEST1'
$Query = 'DBCC SHRINKFILE(TEST1_Log, 1) ;select @@error as ret'

$ret = Invoke-Sqlcmd -ServerInstance $SV -Database $DBName -Query $Query
if ($ret.ret -ne 0) {
    write-host 'エラー'
}

#$Query = "DBCC CHECKDB('" + $DBName +"') ;select @@error as ret"
#$ret = Invoke-Sqlcmd -ServerInstance $SV -Username $UserID -Password $Password -Database $DBName -Query $Query
#if ($ret.ret -eq 0) {$ret1 = "正常"}else{"異常"}