problem with trying to create ssms add-in

Posted by Karl on Stack Overflow See other posts from Stack Overflow or by Karl
Published on 2010-05-29T14:53:43Z Indexed on 2010/05/29 15:02 UTC
Read the original article Hit count: 360

Filed under:

add-in

|

SSMS

I'm trying to create an add-in for SSMS 2008 and/or 2008 R2 but I've run into a problem straight away.

I can get my add-in to work and on SSMS start-up get it to simply show a message box.

However, after downloading various code-samples, when trying to reference Microsoft.SqlServer.Management.UI.VSIntegration.ServiceCache I get a null reference exception:

Commands2 commands = (Commands2)ServiceCache.ExtensibilityModel.Commands;

I get this problem when using SSMS 2008 or SSMS 2008 R2. I'm working on Visual Studio 2010.

It's a bit frustrating because I'm keen to learn more about SSMS add-ins but can't seem to get past the few samples out there.

Any advice/tips appreciated.

Thanks

© Stack Overflow or respective owner

Related posts about add-in

Adding Vertices to a dynamic mesh via Method Call

as seen on Game Development - Search for 'Game Development'
I have a C# Struct with a static method, "Get Shape" which populates a List with the vertices of a polyhedron. Method Signature: public static void GetShape(Block b, int x, int y, int z, List<Vector3> vertices, List<int> triangles, … >>> More
Decompiling a *.DLL to assembly for .net in delphi 4

as seen on Stack Overflow - Search for 'Stack Overflow'
I love my Delphi 4 but at the same time I see the need to talk to windows .net This is a recompiled dll that I found on sourceforge.net/projects/delphinet/ (DelphiNet03.zip) by some nice people that fund the dll from some were. The real answer is to make this dll so that fits into Delphi as true… >>> More
Outlook Addin in C# - How to add button/group in New Mail (next to signatures)

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm having some trouble understanding Outlook terms (CommandBarPopup, CommandBarButton etc) like what is what in Outlook so please be patient. I would like to create couple of things: I would like to create new group (or just button but i read it's not possible to add a button to an existing group… >>> More
Problem rendering VBO

as seen on Game Development - Search for 'Game Development'
I'm developing a game engine using OpenTK. I'm trying to get to grips with the use of VBO's. I've run into some trouble because somehow it doesn't render correctly. Thus far I've used immediate mode to render a test object, a test cube with a texture. namespace SharpEngine.Utility.Mesh { using… >>> More
Visual Studio: Add Item / Add as link rather than just Add

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm new to visual studio, coming from Delphi. I have a directory tree full of .cs files (root is \Common). I also have a directory tree full of Applications (root is \Applications) Finally, I've got a tree full of Assemblies (root is \Assemblies) I'd like to keep my .cs files in the Common tree… >>> More

Related posts about SSMS

Kill your temp tables using keyboard shortcuts : SSMS

as seen on SQL Blog - Search for 'SQL Blog'
Here’s a nifty little SSMS trick that my colleague Tom Hunter educated me on the other day and I thought it was worth sharing. If you’re a keyboard shortcut junkie then you’ll love it. How often when working with code in SSMS that contains temp tables do you see the following message: Msg 2714… >>> More
Updated slide decks from SSMS presentation at SNESSUG

as seen on SQL Blog - Search for 'SQL Blog'
Tonight I spoke at the SNESSUG user group meeting in Warwick, RI. You can download the slide deck here (this is a 3.5 MB PDF with presenter notes): http://sqlblog.com/files/folders/23423/download.aspx If you attended the talk, please feel free to provide feedback at speakerrate.com: http://speakerrate… >>> More
SSMS 2008 Add-In - Execute Query

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm loading a sql script up to an SSMS 2008 add-in like so: ' create a new blank document ServiceCache.ScriptFactory.CreateNewBlankScript(Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptType.Sql) ' insert SQL statement to the blank document Dim doc… >>> More
SSMS - Please get keyboard shortcuts working for schemas

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
My current client is using schemas which is good as it provides nice seperation. However it causes me pain on a daily basis. The reason. I can't use the built in keyboard shortcuts in SQL Server management studio. I can't believe how painfully annoying this is. It's just madness that… >>> More
Running your SSMS client as a domain user even if you’re not in a domain

as seen on SQL Team - Search for 'SQL Team'
I wonder if it is possible to use the SQL Server Management Studio (SSMS) client on my machine with a specific domain user when my machine wasn’t in that domain. In fact, many developers use some SSMS add-ons installed on their machine (with appropriate licenses), which greatly simplify their daily… >>> More