March 7, 2018 at 7:44 am
Comments posted to this topic are about the item SQLServiceAccountSelect
March 9, 2018 at 3:53 am
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
March 9, 2018 at 7:49 am
patrick.slesicki - Wednesday, March 7, 2018 7:44 AMComments 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