Extending Enterprise Manager
-
Hi all,
I have a few ideas that I'd like to pursue with regard to extending the functionality of the Enterprise Manager. Is this possible? Has anybody done this and can offer me some pointers on what to read up on to get me started? I'd specifically like to be able to add some items to the right-click menu and/or additional tabs to the properties dialog boxes.
-
Yes you can do this. I'd read up on "External tools", in BOL.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
Gregory A. Larsen, MVP
-
Somewhere on MSDN they have a couple articles about building MMC add-ins. Not a simple process, but doable I think. If you're looking to put a lot of time into it you might want to wait on Yukon, Im expecting that EM will change substantially.
Andy
-
Checking into BOL on External Tools, I see that this only allows you to add something to the tools menu, but I want to be able to affect the EM interface directly.
Checking into the MSDN, I did find an article about developing MMC snap-ins, but again, I want to be able to affect the EM interface directly. I know there are things you can do to interact with Windows Explorer to offer additional options and I'd like to do the same thing with EM. Right now it looks like it can't be done.
I wonder if Microsoft is making the code available to the EM snap in. Does anyone know?
-
Dont think so. Not sure if you can't hook in, but have not tried it. Might be easier to build an app that just gives you what you need. Not as cool (or useful), but probably faster to do.
Andy
-
Not sure how much trouble but you could potentially get the handle of the EM window and add your item to the context menus but I have never tried this. Best place to ask might be http://www.code-guru.com on their discussion board as to how to add items to an open application. I may be wrong but I do you believe with a lot of effort you could find it in memory and add context menus but not sure how functional you could get.
-
It's quite easy to add asp pages to a custom MMC that includes your EM. If you want to modify EM directly, the files that make up a good portion of it are contained in C:\Program Files\Microsoft SQL Server\80\Tools\HTML by default. I've directly modified these files and scripts myself with a minimum of effort to customize a lot of the functionality of EM, though I do not recommend it. It's quite possible to seriously mess up your EM this way. Of course, in a test enviroment, with time to play, a good understanding of the languages, a little curiosity, and a backup plan, la la la la la la la.......
Gives a lot of insight into what's used where and what calls what as well.
-
Thanks, that's what I'm looking for!
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply