Stack Overflow
Stack Overflow

Questions tagged [ssms-2017]

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

188 questions
16
votes
4 answers

Activity Monitor always Paused in SSMS 17.8.1

Whenever I open the Activity Monitor in SQL Server Management Studio 17.8.1(14.0.17277) the overview always switches to (paused). Even if I choose resume, it quickly changes back to paused. This happens on a variety of SQL Servers and SQL Server…
Izulien
  • 363
  • 1
  • 4
  • 10
13
votes
3 answers

How to debug T-SQL with SQL Server Management Studio 2017?

The latest changelog (18.0 Preview 7) of SQL Server Management Studio announced, that the T-SQL Debugger is deprecated. What are the alternatives for the future? Can someone understand this decision? I fear that removing a fundamental development…
ˈvɔlə
  • 9,204
  • 10
  • 63
  • 89
13
votes
5 answers

'Key not valid for use in specified state. (System.Security)' on registered server import (SSMS)

My computer recently crashed and I am getting things re-installed. I would like to import the list of registered servers I had on my previous PC. I have both the RegSrvr.xml file from G:\Users\\AppData\Roaming\Microsoft\Microsoft SQL…
kneidels
  • 956
  • 6
  • 29
  • 55
12
votes
3 answers

SQL Server Management Studio 2017 Database Diagram Folder Missing

I have SSMS 2017 installed and I want to use it to create an ERD for some of my databases. The documentation online says you just need to right click on the "Database Diagrams" folder under your database in the navigation panel. However, that folder…
N.MORR
  • 441
  • 1
  • 3
  • 15
10
votes
2 answers

SSMS 2017 Could not load file or assembly 'Microsoft.AnalysisServices.AppLocal'

I recently installed Microsoft SQL Server Management Studio 2017.5 in order to connect to some Azure resources. When attempting to connect to any db (including my localhost) I get an error saying: 'Could not load file or assembly…
Tyler Moon
  • 241
  • 1
  • 2
  • 7
7
votes
6 answers

SSMS 2017 Changing font size

I'm using SSMS 2017 and want to make my font larger in the query window. When I go to Tools > Options > Environment > Fonts and Colors > and then change the size of my font and press Ok, nothing changes. The size doesn't get affected in the open…
JDoe
  • 71
  • 1
  • 1
  • 2
6
votes
1 answer

SQL Server Management Studio 2017 change font in grid result

I am trying to change font size in grid result in SQL Server Management Studio 2017. But I dont see how to do this. There is not option in Tools->Option->Fonts->and Colour :(
Elrengil
  • 71
  • 7
5
votes
1 answer

How to set a specific cell to null in SQL Management Studio in combination with SQL Azure

In SQL Management Studio for a local database you can pressCTRL+0 to set a cell value to null With SQL Azure this doesn't work with the following error message: I submitted a bug here:…
Dirk Boer
  • 8,522
  • 13
  • 63
  • 111
5
votes
1 answer

Default Value for DATETIME column in SQL Server Management Studio 2017

Is it possible to create a table with a column that has type DATETIME and give it a default value such as CURRENT_TIMESTAMP or GETDATE()? Is there another way to do this? Screenshot from SSMS 2017
r3dfarce
  • 161
  • 1
  • 2
  • 9
4
votes
5 answers

SQl Managment Studio 18 - Blinking Text Cursor hidden in Query

The I-beam has disappeared. It's starting to make it exponentially harder to type not knowing where I am in the query. If someone knows a fix that would be awesome.
Michael Caliendo
  • 61
  • 1
  • 1
  • 2
4
votes
1 answer

How to backup or script all the Synonyms of the database in SSMS?

How to backup or script all the Synonyms of the database in SSMS?
Neeraj Kumar
  • 771
  • 2
  • 16
  • 37
4
votes
1 answer

SQL Server Dark Theme -- Drop down menu too dark, how do I change it?

I have enabled the 'Dark Theme' on SQL Server 2017. It is all great, but when I right click in my Object Explorer on a task or something, it is too dark to read. Does anyone know how to change this? See screenshot for what I mean. I've gone through…
Emily
  • 105
  • 10
4
votes
2 answers

SSMS can't connect to SSRS

I'm learning the SQL server suite and just installed the Developer Edition. I included in my features the Integration and Analysis Services. As for the Reporting ones, I went back online (as indicated) and download/installed it. Now, in my Start…
Bob
  • 467
  • 1
  • 4
  • 13
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
3 answers

Can't find sqlcmd.exe (SQL SERVER 2017)

I've run into a problem about sqlcmd, In the computer there is SSMS 2017 and I can use SQLCMD MODE in SSMS 2017, but I can't call sqlcmd in command prompt, "'sqlcmd.exe' is not Recognized as an Internal or External Command, Operable Program or Batch…
Chen J
  • 57
  • 1
  • 1
  • 6
1
2 3
…
12 13