Hi,
I'm aware of using SmoApplication.EnumAvailableSqlServers to list network SQL Servers, however I would like to go a step-further and a call the "New Registered Server" dialog (follow the below link), in a similar way that you can use an instance of DataLinksClass to call a udl style connection string builder.
Is this an object that can this be called, or will I need to build it?
http://www.thesalemlot.com/serverreg.jpg
Thanks
Drew
AS SQL Server MS is just a WIndows application built on top of SMO you can′t call this functio, you have to build that on your own. Bu you can take the one Microsoft has built as a template. Simply refelctor the code and take this a a good starting point to built your own register diallog.
HTH, jens Suessmeyer.
http://www.sqlserver2005.de
|||
Well, I'd never heard off Reflector until you mentioned it. But if I understand you correctly, this could really help me for this and future projects. I've download it, but am unsure how to use it. I'd appreciate it if you could spare a moment to explain it. How do I load that particular part of SMO to view the code behind it?
Thanks
Drew
|||Well you have to reflector the code of SSMS to find the appropiate parts. Find the Forms section within the assembly and see what is happening behind the scenes-HTH, jens Suessmeyer.
http://www.sqlserver2005.de|||THANKS FOR REGISTERED MY NEW WINDOW
