Friday, February 10, 2012

Calling the New server Registration Dialog window

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

No comments:

Post a Comment