Stack Overflow
Stack Overflow

Questions tagged [ssms-18]

Use this tag specifically for questions related to SSMS Version 18 Microsoft SQL Server Management Studio 18 is a graphical tool for configuring, managing, and administering all components within Microsoft SQL Server.

36 questions
59
votes
4 answers

SSMS version 18 – no Database Diagrams

I notice that Database Diagrams are not supported in SSMS version 18, any idea why, and is there a way to get the same functionality? And why is the T-SQL debugger gone now?
Brian Battles
  • 971
  • 1
  • 7
  • 19
27
votes
4 answers

How do you debug or step through the code in SQL Server Management Studio 18?

SQL Server Management Studio used to have Debug functionality that would allow to step through the code and watch the values etc. Referring to How to add the Debug button to SSMS v18?, I understand that the functionality is removed from SQL Server…
HappyTown
  • 6,036
  • 8
  • 38
  • 51
26
votes
2 answers

Poor mans T-SQL formatting add-in "Format T-SQL Code" option disabled in SQL Server Management Studio v18.5

Refer to the following screenshot: In the previous versions of SQL Server Management Studio, it was working perfectly. I am using Windows 10 on a desktop PC. Appreciate any help for this :)
Hardipsinh Jadeja
  • 1,180
  • 1
  • 13
  • 30
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
21
votes
7 answers

"Edit Top 200 Rows" not working for SQL Server 16.0 - Express Edition

I am trying to "Edit top 200 rows" in SQL Server Express edition, but it's returning with the blank file as shown here: Showing blank file with disable tools I have installed this SQL Server on premise. I can select the data and update the data with…
Usman Javaid
  • 501
  • 3
  • 7
14
votes
5 answers

SSMS 18.8 crashes when re-docking tabs

When I un-dock a tab in SQL Server Management Studio and later attempt to re-dock it, SSMS crashes. This happens every time, and I can reproduce the problem at will. All I have to do is un-dock a tab (let's say, in order to view two SQL queries in…
Variant Fox
  • 381
  • 2
  • 6
10
votes
1 answer

How can I create an SSMS extension that opens from the execution plan window?

I would like to create an SQL Server Management Studio v18 extension that opens from the execution plan window. I believe that this is technically possible because there is a third party tool that already does this: So far, I've been able to create…
Joe Obbish
  • 127
  • 4
4
votes
1 answer

SSMS Scripting Options

Scripting a function using SSMS 18.0 Preview 6 produces the following script. /****** Object: UserDefinedFunction [dbo].[sfn_Proper_Case] Script Date: 7/13/2019 9:57:36 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS…
AeyJey
  • 2,111
  • 2
  • 14
  • 21
3
votes
0 answers

Failed to create DAX script in SSMS v18.5.1 - Object reference not set to an instance of an object

I am not able to open new "Analysis Services DAX Query" in SQL Server Management Studio (SSMS) v18.5.1. SSMS DAX Error print screen Error details: Failed to create new DAX script. ------------------------------ ADDITIONAL INFORMATION: Object…
jackie4u
  • 31
  • 3
3
votes
0 answers

SSMS 18 and Source Control Integration ie. TFS

I am able to get Team menu in SSMS 17.x by following steps described here Now, I have upgraded to SSMS 18.4 and I am able to get Source Control Option in Tools Menu --> Options by changing ssms.pkgundef file at location C:\Program Files…
IgnitedMind
  • 307
  • 5
  • 17
2
votes
0 answers

SSMS 18.12.1 crashing intermittently

A number of us at my job have had issues with SSMS restarting periodically throughout the day. This has happened across a number of SSMS versions and over VPN connections as well as on PCs on the local network. This morning is particularly bad -…
PiperKeith
  • 86
  • 5
2
votes
1 answer

SSMS18 How to connect to a local server?

I've been working on SSMS18 for the longest time, but I'm mostly connecting to a remote SQL server. But now I'm trying to connect to my localhost server but it's just now that I can't connect. I've already searched some tips online but nothing seems…
John Phillip Abello
  • 183
  • 2
  • 14
1
vote
1 answer

SQL Server Import and Export Wizard has stopped working

Am trying to use the Import and Export Wizard within Microsoft SQL Server Management Studio (right click database name > Tasks > Import Data) but immediately get this error; SQL Server Import and Export Wizard has stopped working This process has…
barrlitt
  • 11
  • 4
1
vote
0 answers

Can't open SQL Server Management Studio 18 - "MRU Package did not load correctly" and "Cannot create the window"

This issue is driving me crazy. I can't open SQL Server Management Studio (SSMS) 18. When I try to open it I get the follow things: Starts fine with the small window that says "Microsoft SQL Server Management Studio v18.6"... But then I get an…
Kurka
  • 11
  • 3
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 3