Powershell / SQL Server · 2016-03-18

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"