van-thieu

Get-SqlDatabase and Invoke-Sqlcmd Piping

2

Is it possible to do the below? $Database = Get-SqlDatabase -ServerInstance $Server -Name $Name $Database | Invoke-Sqlcmd -Query "Insert Into..."

Possible to include a maximum .bak file size and have it automatically split backup into multiple files? Example: Backup-SqlDatabase -MaxFileSize 150GB

PowerShell Write-SqlTableData Computed Column Error

1

Cannot insert new data onto table when a computed column exists, returned below error: The column "A" cannot be modified because it is either a computed column or is the...