Ssms 18 -

if (File.Exists(recentConnectionsPath)) { // Parse MRU (Most Recently Used) connections Console.WriteLine("Recent connections file found at: " + recentConnectionsPath); // Note: SqlStudio.bin is a binary file; you may need to parse it specifically } // Alternative: Check Registered Servers string registeredServersPath = Path.Combine( Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), "Microsoft\\SQL Server Management Studio\\18.0\\RegisteredServers.xml" ); if (File.Exists(registeredServersPath)) { ReadRegisteredServers(registeredServersPath); } }

private static void ReadRegisteredServers(string xmlPath) { XmlDocument doc = new XmlDocument(); doc.Load(xmlPath); XmlNodeList servers = doc.SelectNodes("//ServerInstance"); foreach (XmlNode server in servers) { Console.WriteLine($"Registered Server: {server.InnerText}"); } } } using System; using System.Runtime.InteropServices; public class SSMSAutomation { public static void ConnectToDatabase() { Type ssmsType = Type.GetTypeFromProgID("SqlServerManagementStudio.SsmsApplication"); ssms 18

foreach (var path in paths) { if (File.Exists(path)) return true; } // Check registry using (RegistryKey key = Registry.LocalMachine.OpenSubKey(@"SOFTWARE\Microsoft\Microsoft SQL Server Management Studio\18.0")) { return key != null; } } if (File