Stack Overflow
Stack Overflow

Questions tagged [ssms-addin]

29 questions
24
votes
1 answer

How to Create an Extension for SSMS 2019 (v18)

SQL Server Management Studio 18 RC1 became available March 28, 2018 This question has already been asked for SSMS 17, but there are slight variations when authoring extensions for different releases of SQL Server Management Studio. What are the…
KyleMit
  • 30,350
  • 66
  • 462
  • 664
13
votes
5 answers

Is there a way to expand the column list in a SELECT * from #Temp_Table in SSMS?

As seen here LINK you can hover over the * in a SELECT * from... and a tooltip will come up with a list of the columns represented by that *. Is there a way to copy the text from the tooltip to the clipboard? I know that you can use the columns…
Daniel E.
  • 2,029
  • 3
  • 22
  • 28
9
votes
2 answers

How to get vertical tabs in SSMS?

Is it possible to get the window tabs in a vertical row? That way I can navigate to way more windows directly, using the mouse. I know there are paid tools available, but using them is not an option in my working environment... I fear this will…
Steef
  • 303
  • 2
  • 11
6
votes
2 answers

How to update SQL addins to work in SSMS 2016?

Years ago I wrote an addin to do specific things I want in SSMS. I use it all the time and have gone through the pain of working out how to get it running again each time a new version of SQL server breaks the addin model. I've now installed SSMS…
Reg Edit
  • 6,719
  • 1
  • 35
  • 46
5
votes
1 answer

How to create SQL Server add-in?

i try to develop an add-in for SQL Server Management Studio like this: http://aspalliance.com/1374_Extend_Functionality_in_SQL_Server_2005_Management_Studio_with_Addins.all But: I've searched in google about SSMS add-ins. I've found a link which is…
loki
  • 2,926
  • 8
  • 62
  • 115
4
votes
2 answers

How to create extension for SQL Server Management Studio 17 in C# in VS2017?

I followed simple Hello World sample from Create your first extension: Hello World example from the Microsoft Docs to build an extension for SSMS 2017 Created VSIX project from Extensibility project template Changed "Start External Program" in…
Chirag Rupani
  • 1,675
  • 1
  • 17
  • 37
3
votes
2 answers

Does the Poor Man's T-SQL formatting add-in for Management Studio 2012 work in Management Studio 2016?

Basically the same question as this but now for SSMS 2016. I've installed SSMS 2016 RC3 (alongside SSMS2012 & SSMS2014). I also installed Poor Man's formatter and copied the 11.0 folder as 12.0 and 13.0. When launching SSMS2014 I have the Tools >…
MarcS
  • 31
  • 1
  • 2
3
votes
1 answer

SSMS Add in - accessing Results Pane

I am attempting to write a SSMS add in (either 2008 R2 or 2012) in C#. The goal is to allow right clicking on a field in the results pane, and have the context menu provide pre-written queries based on the field selected. I have successfully created…
user2228295
  • 31
  • 2
3
votes
3 answers

SSMS 2012 Addin - ObjectExplorerService not available in SSMSAddinDenali

This question is in reference to the SSMSAddinDenali SQL Server Management Studio 2012 Addin found here http://ssmsaddin2012.codeplex.com/SourceControl/changeset/view/19629#101185. I cannot implement IObjectExplorerService using .Net 4.0/4.5 while…
user975249
2
votes
6 answers

Add-In for keyboard shortcut to select current block or execute current block in sql server management studio query window?

In TOAD, you have keyboard shortcuts where you can select the current block or execute the current block....so if you are working on a large sql query, when you make a modification, you can just do a CTRL+ENTER (or something like that, can't recall…
tbone
  • 5,715
  • 20
  • 87
  • 134
2
votes
1 answer

Grantor does not have GRANT permission

I have a gitlab user and a role assigned to it, now the gitlab user needs extra grant permissions. I am executing the following sentence. [ssms 2012] GRANT VIEW SERVER STATE to xxx; ERROR: Grantor does not have GRANT permission What is the…
user6826691
  • 1,813
  • 9
  • 37
  • 74
2
votes
0 answers

how can I output something to the SSMS "Messages" tab from an SSMS add-in

I'm working on an SSMS 2014 addin, and I need to output stuff to the messages tab of the active document. I know I can get that document like this : var document = ((DTE2)ServiceCache.ExtensibilityModel).ActiveDocument; but I've not been able to…
Brann
  • 31,689
  • 32
  • 113
  • 162
2
votes
2 answers

Re-enable SSMS Addin

I'm sure this is very simple but I can't seem to find an answer to this at the moment and my googling powers have returned nothing. I previously had an issue with an Addin and SSMS gave me the option to disable it (which I took). I have since…
OCDan
  • 1,103
  • 1
  • 10
  • 19
2
votes
2 answers

SSMS Extensibility Project - howto research/debug

In the vein of this answer regarding creation of an SSMS Extension: namespace SSMSAddin { using System; using System.IO; using Extensibility; using EnvDTE; using EnvDTE80; using Microsoft.VisualStudio.CommandBars; using…
WernerCD
  • 2,137
  • 6
  • 31
  • 51
1
vote
0 answers

SSMS 18 VSIX project. Modify query window contents

Since SSMS 18 has dropped the requirements for Package IDs for SSMS Extensions I thought I'd give it a go. Being totally new in this area, I'm not sure where to start. I've gotten as far as a menu item in tools as per various tutorials out…
Tikeb
  • 978
  • 3
  • 9
  • 25
1
2