Questions tagged [ssms-18]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
31 views

SSMS How to Click within Query to Open Table

I come from oracle SQL Developer world where I can ctrl+click on a table name within a query and the table definition automatically opens. This is great as it alleviates my need to navigate within ...
1
vote
0answers
51 views

SQL Server “Locate backup file” change to include diff

In SSMS, when using the GUI to select backup files to restore, the .diff are excluded (First image) and you need to change to show all files (second image). .diff is the file extension I am using for ...
6
votes
1answer
302 views

SQL Server Management Studio - Why is Dark Theme Disabled by Default?

Why is the Dark theme disabled by default? Are there some bugs with this theme or something along those lines? It seems odd to me that it is forcible disabled on purpose. I found plenty of links ...
0
votes
1answer
26 views

“Cannot open user default database. Login failed” after altering MDF and LDF locations and bringing DB offline

I was attempting to move my database to a separate hard drive on the server, so I ran the following commands in the following order (I was following this question : How to change location of SQL ...
2
votes
1answer
45 views

Graphical Actual Execution Plan - Estimated vs Actual number of rows

I am using: SQL Server Management Studio v18.1 SQL Server 2017 CU9 AdventureWorks restored from here Test query: USE [AdventureWorks]; GO SELECT TOP (13) * FROM Sales.SalesOrderHeader AS s ...
0
votes
0answers
56 views

SQL AlwaysOn Dashboard Not Showing Green Circles

I have a SQL server 2017 with SSMS 18.1 and SAO dashboard shows gray circles instead of the green check marks. It does not matter if it is secondary or primary it always shows grey circles. The server ...
1
vote
1answer
59 views

Conext menu behaviour change in SSMS 18.0/18.1 [closed]

I'm using the new SSMS 18.0 or 18.1 and one thing extremely annoys me - Upon pressing right click, the context menu is open. I used to press the "up arrow"+"Return key" to pick the Refresh option. ...
4
votes
1answer
69 views

Is it possible to use just one shared folder for log shipping?

I wonder if it is possible to use one shared folder(only in source database) instead of two (one in source db and another in destination db). That's Server1 will store its t-log backups there and ...
4
votes
3answers
2k views

Drag and Drop table object explorer into query window issue Sql Server Management Studio 18.1

I recently installed SSMS 18.1 and I am having an issue when trying to drag and drop table names from the object explorer to the query window. For example, I am writing a query and dont want type out ...
2
votes
2answers
2k views

SSMS refuses to start [duplicate]

I've recently installed SQL Server 2017 Express and SSMS v18.0 on my home computer (Windows 10) and at first this worked fine. However, after a reboot, SSMS flat out refuses to start. No error message,...
2
votes
0answers
306 views

SSMS 18.0 switching between tabs problem [closed]

Does anybody have the same problem with new SSMS 18.0? I have opened more tabs with some code inside. When switching between tabs the window (code inside the window) is rendered slow and the code is ...
105
votes
6answers
55k views

SQL Server Management Studio 18 won't open (only splash screen pops up)

I just installed SSMS 18 GA on a computer with only VS2019 installed, and when I try to open SSMS the splash screen will come up, but then the process exits. Running ssms with the -log parameter ...