External Tool Development for SQL Server Management Studio 2005

Question

Hi All,

Does anyone have any experience of developing external tools for SSMS 2005.

Ideally I would like to be able to interact with the query windows directly, for example, taking the query text from the window to perform some processing on it.

Any pointers in the right direction would be great.

Thanks in advance

Answer 1

Have you looked at Sql Server Management Objects (SMO)?

http://msdn.microsoft.com/en-us/library/ms162557.aspx

Answer 2

The best example of this I have seen for SSMS is SQL Prompt by Red Gate

SQL Prompt runs a seperate .NET app that sits in your systray and is in some way part of the magic of the integration.

For loading an add-in, you will want to create a key under:

HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\90\Tools\Shell\AddIns\

...in order to have SSMS load your add-in.

Hope this helps

Answer 3

Very late entry...

Example of how to do it here

And here too