Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: Store PowerShell result in a table

    This fixed the issue.
    Thanks a lot for your help.

  • RE: Store PowerShell result in a table

    I install SQLServer module and tried again but getting the same error: See below:

    PS SQLSERVER:\> Get-Module SqlServer -ListAvailable

      Directory: C:\Program Files\WindowsPowerShell\Modules

    ModuleType Version ...

  • RE: Store PowerShell result in a table

    Thanks for your reply.
    I wrote the following script:
    $server = get-content "C:\Users\sql_dba_test\Desktop\servers.txt"
    Foreach ($s in $server)
    {

    Invoke-Sqlcmd -Query "
    SELECT host_name,COUNT(*) AS [Connections]...

Viewing 3 posts - 1 through 3 (of 3 total)