Powershell - Invoke-SqlCmd, retrieving PRINT statements asynchronously

I would like to know if it开发者_运维百科s possibly to retrieve PRINT statements from a stored procedure asynchronously?

Currently the code below, only displays all the PRINT systems once the stored procedure has been executed.

"Invoke-Sqlcmd -ServerInstance $sql_server -Username $sql_usr -Password $sql_pwd -Database $sql_db -QueryTimeout 6000 -Query "EXEC TV.StoredProdure $cob_date, $region" -Verbose"

Any assistance will be greatly appreciated.

---

No.

PRINT will only display once the command has completed, whether you run it from OSQL, SSMS, or Powershell.

What you CAN do is use RAISERROR to get immediate feedback:

RAISERROR('This will display immediately',0,1) WITH NOWAIT