Home Forums Programming Powershell Powershell to get Results and Messages in SSMS inquiry RE: Powershell to get Results and Messages in SSMS inquiry

  • September 24, 2017 at 5:38 am

    #1960637

    SQLCMD does return the number of rows. At least Version 13 on Linux does:
    [username]@ihy:~$ sqlcmd -S localhost -U [Username] -Q "SELECT @@ServerName AS ServerName;"
    Password:
    ServerName                                       
    --------------------------------------------------------------------------------------------------------------------------------
    ihy                                         

    (1 rows affected)
    I did also give it a quick go on my Windows laptop and got the same (I think that has Version 13 as well, if not 12).

    Could you be a bit more specific?

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk