CODEWITHSUNDEEP
sql-server-2005ssms
jheppinstall
jheppinstall

Reputation: 2358

External Tool Development for SQL Server Management Studio 2005

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

Upvotes: 1

Views: 3015

Answers (4)

vinay1
vinay1

Reputation: 11

This link explains adding external tools to ssms with screen shots. It also has procedure to add them as a button. http://sqlserverlearner.com/2011/sql-server-external-tools

Upvotes: 1

gbn
gbn

Reputation: 432210

Very late entry...

Example of how to do it here

And here too

Upvotes: 1

James Green
James Green

Reputation: 1837

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

Upvotes: 1

Mark Bostleman
Mark Bostleman

Reputation: 2205

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

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

Upvotes: 1

Related Questions