SQLServiceAccountSelect

  • Comments posted to this topic are about the item SQLServiceAccountSelect

  • Thank you for posting this nice little script.
    I've just found one little issue when running in my environment.

    I call named instances 'MSSQLSERVER1', 'MSSQLSERVER2' etc.
    When running your script the result in the 'SQLServerInstance column is 'default1', 'default2' etc.

    A solution to replace instancename on the default instane only, could be using CASE instead of REPLACE:


    ,SQLServerInstance =
             CASE InstanceName
                WHEN 'MSSQLSERVER' THEN 'default'
                ELSE InstanceName
             END

    // Christian

  • patrick.slesicki - Wednesday, March 7, 2018 7:44 AM

    Comments posted to this topic are about the item SQLServiceAccountSelect

    Patrick - thank you vey much.  Very useful - don't need RDC just run and get an idea what is going on there.  Vlad

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

You must be logged in to reply to this topic. Login to reply