Skip to content

Sql Server Powershell

Day: July 12, 2017

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
Scott Newman Powershell, SQL Server Leave a comment July 12, 2017 1 Minute

Twitter

Error: Please make sure the Twitter account is public.

Posts

  • November 2021 (1)
  • February 2021 (1)
  • November 2020 (2)
  • October 2020 (2)
  • October 2019 (1)
  • February 2019 (1)
  • November 2018 (2)
  • April 2018 (1)
  • November 2017 (1)
  • October 2017 (1)
  • September 2017 (1)
  • July 2017 (1)
  • June 2017 (1)
  • April 2017 (3)
  • October 2016 (1)
  • July 2016 (13)
  • January 2016 (1)
  • September 2015 (2)
  • May 2015 (1)
  • April 2015 (1)
  • March 2015 (2)
  • February 2015 (2)
  • January 2015 (1)
  • December 2014 (3)
  • September 2014 (3)
  • August 2014 (2)
  • May 2014 (2)
  • April 2014 (4)
  • March 2014 (3)
  • February 2014 (3)
  • January 2014 (4)
  • November 2013 (1)
  • August 2013 (2)
  • June 2013 (1)
  • May 2013 (3)
  • April 2013 (4)
  • March 2013 (2)
  • February 2013 (16)
  • January 2013 (1)
  • December 2012 (4)
  • November 2012 (1)
  • October 2012 (5)
  • September 2012 (3)
  • August 2012 (2)
  • July 2012 (3)
  • June 2012 (2)
  • May 2012 (2)
  • April 2012 (4)
  • March 2012 (1)
  • February 2012 (1)
  • January 2012 (6)
  • December 2011 (8)
  • November 2011 (5)
  • October 2011 (14)
  • July 2011 (7)
  • May 2011 (1)
  • April 2011 (1)
  • February 2011 (3)
  • January 2011 (2)
  • December 2010 (1)

RSS

  • RSS - Posts
  • RSS - Comments

Archives

Blog Stats

  • 166,329 hits

Follow me on Twitter

My Tweets
July 2017
M T W T F S S
 12
3456789
10111213141516
17181920212223
24252627282930
31  
« Jun   Sep »

Tags

Blog at WordPress.com.
  • Follow Following
    • Sql Server Powershell
    • Already have a WordPress.com account? Log in now.
    • Sql Server Powershell
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar