PowerShell – Query Database Remotely

The basic syntax for sending a query to SQL Server using PowerShell.

sqlcmd -S SERVER_NAME -d master -Q "select count(1) from sys.objects"

  • 2016-03-18