Capture Sql Messages output to Variable

To capture the sql output messages (what you see in the “Messages” tab in SSMS) you can use this:


$results = (Invoke-Sqlcmd -ServerInstance "ServerName" -Database master -Query "BACKUP DATABASE [master] TO DISK = N'c:\master.bak' WITH Stats = 5" -Verbose | Out-Null) 4>&1
$results

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.