Hi all (sorry for my english)
I want to do an analysis for know some information SQL server.
i have un problem, i want to know collation language for each instance SQL.
I know how to know how find SQL
q: ((names of parent key of it) of keys “Setup” of keys (values of keys “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL” of native registry as string) of keys “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server” of native registry)
A: MSSQL11.BIGFIX
if i want to know all multi instance i put
concatenation “;” of ((names of parent key of it) of keys “Setup” of keys (values of keys “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL” of native registry as string) of keys “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server” of native registry)
That give me all instance.
if i put full keypath for collation:
q: value “Collation” of keys “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.BIGFIX\setup” of native registry
A: SQL_Latin1_General_CP1_CI_AS
All is ok
But my instance SQL can have other name or mutli.
How can i conctatenate :
value “Collation” of keys
"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server"
+
((names of parent key of it) of keys “Setup” of keys (values of keys “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL” of native registry as string) of keys “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server” of native registry)
+
"\Setup” of native registry)
thanks for you help