• When using the Invoke-Sqlcmd, include the -Verbose option. That will output the "messages" tab from SSMS.

    PS U:\> Add-PSSnapin sqlservercmdletsnapin100

    PS U:\> Invoke-Sqlcmd -Query "select 'test'; PRINT N'123';" -Verbose

    Column1

    -------

    test

    VERBOSE: 123

    PS U:\>