Questions tagged [ssms]

SQL Server Management Studio, a graphical front-end tool shipped with SQL Server for managing and querying databases. It also supports managing other bundled systems such as SSAS.

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

Search SQL Server Execution Plan by cost in SSMS

I was given a large Execution plan and I'm trying to find the nodes connected to high costs. SSMS offers a search util, however, I did not find the option that searches for the cost value in percent. ...
3
votes
0answers
112 views

Slow Connection to Azure SQL Database using SQL Server Authentication

In SSMS, when connecting to any of our Azure SQL Databases using service accounts and SQL server authentication, the connecting itself can take between 10 to 15 seconds to establish. Once connected, ...
2
votes
1answer
4k views

Databases list not showing up?

This morning when I logged into SQL Server Management Studio (v 10.0.16) I clicked on the databases node and saw all by db's (they are hosted remotely) as I have done for the last 3 years. This ...
6
votes
2answers
1k views

What is the right tool to process big .xel files (SQL Server Extended Events logs)?

My aim is to audit all queries on an instance, who's running them and from where, how many reads, in order to consolidate/migrate on another instance. Figured out the best way is via Extended Events ...
0
votes
0answers
9 views

How to make replication continue to work after repairing?

I would like to share with you a problem I faced today and will be glad if you can help me to tackle that issue. The issue related to transactional replication. So, let's go step-by-step to know how ...
0
votes
2answers
109 views

Accessing Registered Servers over Excel

With DBs in different countries, different servers but same structure, I have created registered server to access them when running certain queries for reports on SSMS. Thus far this is ok. However, I ...
0
votes
1answer
54 views

lost all my databases after reinstalling sql server management studio

SQL server management studio was not working so, after googling this issue, I found that I have to reinstall it. So, after re installation, I lost my database and I didn't get a backup of it. So, is ...
2
votes
1answer
681 views

SQL Server was unable to communicate with the LaunchPad service

I have run the below code: execute sp_configure 'external scripts enabled'; and it is giving me the output as: name minimum maximum config_value run_value external scripts ...
1
vote
0answers
10 views

Is there a way Azure data studio to find and add local databases under a list automatically?

When I create a database locally in SSMS it does not show up automatically in ADS. I have to add it as a connection each time. Generally I use SSMS but am trying to switch away (or just try for fun) ...
19
votes
4answers
36k views

How to clone a user in SQL Server 2008 R2?

Is there a way to clone users' security and permissions in Microsoft SQL Server, preferably using the SQL Server Management Studio GUI?
4
votes
3answers
742 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 ...
13
votes
2answers
4k views

How to add the Debug button to SSMS v18?

The Debug button is present on this version of SSMS: But it is not present on version 18, preview 4: I have tried in several ways to add the Debug button to my SSMS but not successful. Is there a ...
0
votes
2answers
342 views

INSERT INTO SQL Server : Linked Server without specifying database in semi-fully qualified name

I have a server called DEV, a database called Nus12345, a linked server called SnapshotDev, a schema called Snapshot, and a table called SnapshotPersonEmployee. On the DEV server, there are many ...
1
vote
2answers
32 views

Registered Servers without the ability to connect to Multiple Servers at once

I'd like to provide a "directory" of all the different SQL Servers we have our different DEV, TEST, PROD environments by setting it up in Central Management Servers. Another DBA said to be cautious ...
0
votes
0answers
26 views

Unable to Create new Maintenance plan in SSMS 2017

Hi I have reinstalled SQL Server 2016 in my database server last day. I am able to connect to SQL Instance(SQL-02) using the SSMS 2017 i had earlier in the same server before reinstall. But when i ...
0
votes
1answer
20 views

Searching all databases in environment [duplicate]

I need to be able to search for SQL objects (logins, etc). With a smaller number of servers, I would connect to them all via a registration group in SSMS and do the search. Does anyone have a better ...
1
vote
0answers
9 views

SQL Vulnerability Assessment Error in PowerShell

I am running Vulnerability Assessments against my SQL Servers and databases using the PowerShell cmdlets Invoke-SqlVulnerabilityAssessmentScan and Export-SqlVulnerabilityAssessmentScan, however, I am ...
11
votes
4answers
8k views

Restore Database wizard won't open in SSMS 2014

On a dev machine running Windows Server 2012 R2, I just upgraded SQL Server from 2012 to 2014. Using SQL Server Management Studio 2014, when I right-click a database and go to Tasks -> Restore -&...
0
votes
1answer
92 views

Some queries not logging using RDS's SQL Server with C2 Auditing enabled

Similar to a past issue I had with audited queries not showing when using Extended Events, I'm having an issue with queries not logging when using C2 Auditing on an RDS SQL Server instance. (I would ...
1
vote
2answers
3k views

“Untrusted Domain” error when connecting to SQL Server localhost and specifying port

I have two SQL Server 2016 instances running on localhost, and I can connect to both with no issues (localhost and localhost\test) using windows authentication. However, if I specify the port ...
0
votes
0answers
47 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 ...
2
votes
2answers
72 views

Connecting to SQL Server with SQL Server Management Studio

I've just install SQL Server 2017, it showed this window: When I open SQL Server Management Studio it has default Server Name as DESKTOP-6ECNPU1\matt which is the SQL Administrator value of the ...
5
votes
3answers
2k views

SSMS Restore Database wizard slow to respond

I've just noticed this recently on one of the SQL Server 2012 SP3 instances that I oversee. When I try to restore a database using SSMS 2012 (by right-clicking on the database,and choosing Tasks>...
0
votes
1answer
210 views

Static Data Masking does not appear in SSMS 18 preview 6

I installed SSMS version 18 preview 6 and am using it with SQL Server 2017. I want to test the Static Data Masking feature, but the option does not appear.
0
votes
1answer
18 views

What will happen if master goes down in peer to peer replication?

In case of Peer to peer replication, if Master goes down, will the other two nodes continue synchronizing or not?
1
vote
1answer
45 views

Using PIVOT to convert multiple rows and columns

So my current query output is as follows: I would like to consolidate all of these rows to just one long row like so: MyID Customer relc_rate relc_consumption relc_daysofservice ...
0
votes
1answer
54 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. ...
0
votes
1answer
13 views

Change defaults of SSMS generating script

In Microsoft Sql Server Management Studio most of times I need a set of advanced settings when generating script. For example I need to set "Script Drop and create" to true and "script extended ...
0
votes
0answers
19 views

Failed Login on Registered Server When Opening Connection

I have a number of servers registered in the Registered Servers pane in SQL Server Management Studio. When I right click a server group and select "New Query", a window opens in which I can execute a ...
0
votes
2answers
161 views

MSSQL Instance Alias - how does it work

Ok I'm trying to understand how a MSSQL Alias works but documentation is lacking to say the best. Most blogs/videos/documents I can find state that all you need to do is go to SQL Server ...
0
votes
1answer
18 views

What kind of changes does snapshot file store?

Assume that I created a database called [DBS] and inside that database I created a table called [products]. Then I inserted 4 rows into [products]. Afterwards I took a snapshot of [DBS]. As a result,...
2
votes
0answers
34 views

Keyboard shortcut to automatically wrap selected text in IsNull([text], 0) in SSMS [migrated]

Is there some way to have a shortcut in SQL Server Management Studio (SSMS) that when text is selected, it wraps that text in an IsNull() statement? For example, I highlight the text below: ...
-2
votes
1answer
45 views

How can I find out who's logged on to database?

I'm trying to rename a database in SSMS and I get this error: The database could not be exclusively locked to perform the operation So how can I find out who or what is using this database? I don't ...
1
vote
1answer
42 views

Show backups at server level

I have an SSRS report which shows the 'last backup time' next to each server in the list. I am getting this information by using: SELECT TOP 1 @@SERVERNAME as serverName, sdb.Name AS DatabaseName, ...
1
vote
1answer
78 views

SQL Server Database Diagram

I am using SSMS v18, I need to create an ER diagram from my database. As Microsoft removed diagram from new version of SSMS (v18) so now How can I get a diagram for my database??
1
vote
0answers
19 views

SSMS - Can I create a default layout?

Using SSMS 11 to connect to a SQL Server 2012 instance. When I first load up SSMS and log-in, is it possible to have specific nodes in the object explorer expand? I always expand the tables node in ...
1
vote
2answers
68 views

SQL Server - Physical Table Design - Column Order - Null and Non Null Columns

We are in the process of building out a database for a new application. I got some feedback from the architect that he read somewhere there is a memory utilization benefit for having all of the non-...
1
vote
4answers
5k views

SQL Server: SSMS “Save Results As” creates CSV that Excel mangles

Using the Save Results As option, shown below. CSV looks good! But when Excel opens/imports it: Long strings are mangled as numbers (if the data is largely numeric) Dates are not detected properly ...
94
votes
5answers
44k 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 ...
1
vote
0answers
47 views

Converting show-plan XML to graphical view plan

I am using the performance dashboard to set up baseline monitoring for my inventory of SQL servers. As per the performance dashboard available within SSMS, when i click on any query to view the plan ...
2
votes
1answer
39 views

Call Powershell command string from Sql Query Publish profile script

Is there a way to call powershell in SSMS Sql query window? I know Command prompt can be invoked with xp_cmdshell. Does similar method for powershell exist ? (Note, I know about powershell window , ...
0
votes
2answers
55 views

Are the switches for the SQLCMD command case sensitive?

I have MS SQL Server 2014 Management Studio installed on two computers, both of which run on Windows 10. The switches for SQLCMD command are case-sensitive on one computer, but it is not on the other ...
0
votes
0answers
47 views

SSMS v18.0 failed when installing

Previously, I had installed the SSMS v17.9. I uninstalled it and tried to install v18.0 and I have the error 0x80070643. I tried the following: Installing the latest .Net Framework 4.8 Updating ...
2
votes
1answer
286 views

SQL Server managed backup missing in ssms

Trying to configure Sql Managed backup to azure, and it seems that "Managed backup" is missing from the GUI under Management in SSMS 17.2 All guides I see kind of implies that it's already there. But ...
5
votes
2answers
300 views

How to prevent SQL files opening new instances of SSMS 17.9.1?

Synopsis This is not a new problem and there are several solutions floating around on Internet. Problem When you double click on a .sql file, a new instance of SSMS is opened. I did not have this ...
1
vote
3answers
1k views

SQL Server Management Studio 17.1 Mirroring bug

I noticed there is a bug that when people asked about it, they were sent in the wrong direction (see final remarks below). When trying to use SQL Server 2016 with SSMS 17.1 to create a mirrored ...
2
votes
1answer
46 views

Error: 468 trying to connect to SQL server with SQL Server management studio

I'm trying to connect to SQL Server 12 with SQL Server management studio 2014. The connection is succesful, but when I try to see properties of a specific database with mouse right button I get this ...
0
votes
2answers
32 views

What is a Data Source and where can I find it in SSMS?

I have just recently started using SQL Server Management Studio. After some hitches, I have managed to create a Database. Inside the DB I have also created some Tables and populate them. Now I am ...
2
votes
2answers
830 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,...
0
votes
1answer
1k views

Adding a domain user in SQL Server Management Studio

Before I ask my question, let me mention that my SQL Server is installed on a member server of a domain (it belongs to the domain but is not an AD server). I am having trouble adding a network user ...