Questions tagged [ssms-18]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
9 views

SSMS 18.4 Error opening database properties dialog box Azure SQL DB Managed Instance

I have three databases in an Azure SQL DB Managed Instance. I am using SSMS 18.4. One database I can right-click, choose Properties, and the dialog box comes up normally. The other two databases give ...
8
votes
1answer
143 views

Permissions required for row counts to show up on Object Explorer Details

I'm having a weird security issue. I have a user that's using SSMS 18.2 on a SQL 2016 server. They are a member of db_datareader but when they pull up the the Row Count column in Object Explorer ...
0
votes
1answer
39 views

How to fix error editing job step properties in SSMS 18?

Whenever I try to edit the properties of a SQL Server Agent job step in SQL Server Management Studio (SSMS) version 18, the application throws an error and I cannot proceed. How do I fix that error? ...
0
votes
3answers
55 views

how to automate DB restore to another server?

The plan is to have 1 backup set that will contain full and transactional log backup. (Server1) There is already a scheduled job that will append any transactional log to the file after 30 minutes. (...
0
votes
0answers
53 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
61 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
589 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
97 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
84 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
64 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
61 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
92 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
3k 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
3k 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,...
3
votes
0answers
624 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 ...
106
votes
6answers
63k 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 ...