Viewing 3 posts - 1 through 3 (of 3 total)
This fixed the issue.Thanks a lot for your help.
March 6, 2018 at 2:33 pm
#1982154
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 ...
March 6, 2018 at 11:46 am
#1982117
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]...
March 6, 2018 at 9:43 am
#1982101