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
0answers
12 views

Data Loss issue while migrating data from Source(Oracle) to Data Warehouse Staging Database(SQL Server)

Project Overview Loading data from Oracle Database to Datawarehouse Staging Database(SQL Server). Using ETL process we are loading data from Oracle to SQL Server. Staging Database in SQL server is an ...
1
vote
0answers
14 views

How to Parse a query in Azure Data Studio?

In Sql Server Management Studio, we can click a "Parse" button (or Ctrl+F5) to verify that a SQL statement is syntactically correct (without executing it). How can I do it the same in Azure Data ...
1
vote
1answer
30 views

When are statistics created?

I know that when we create an index then statistics are automatically created. My question is: Is it the only case when statistics are created? I remember that once I found on the internet that we ...
0
votes
0answers
8 views

Using CONVERT on Always Encrypted varbinary column

I have an encrypted varbinary column that contains data that I wish to convert to varchar using the CONVERT() function. I am using Always Encrypted = ON and Column Encryption Setting = Enabled for my ...
2
votes
1answer
28 views

SQL Server Configuration Manager is not showing SQL Services

I have newly installed following things on my system - Microsoft SQL Server Management Studio 2014 - SQL Server 2017 - Visual Studio 2015 When I tried to open SSMS for the first ...
0
votes
0answers
19 views

Import folder with Multiple CSV's into SSMS w/ out SSIS

I am wondering what's the best and most effective way to import csv's stored in a local folder into DB w/ in SSMS. Folder path- C:\Users\ngutierrez\Desktop\Open_Air_Tables Folder contains about 30 ...
8
votes
1answer
579 views

How to disable “Completion time:…” in SQL Server Messages window

Every query I run in SSMS append the annoying message: "Completion time:...". How can I disable that text?
2
votes
1answer
26 views

SQL Server seems to be ignoring specified backup file extension

I have created a maintenance plan using the Wizard and this is the SQL produced, per SSMS: BACKUP DATABASE [FOO] TO DISK = N'C:\SQLBAKS\FOO\FOO_backup_2019_08_09_161656_6414445.diff' WITH ...
0
votes
1answer
15 views

Is it possible to configure backup filename conventions for Maintenance Plan Wizard in SSMS

Is there a way to configure SSMS so that the backup file names for differential backups (created using the Maintenance Plan Wizard) would have the string "DIFF" in the name?
-2
votes
2answers
51 views

get data from express edition db to developer edition [closed]

Hi I've installed freshly db of ssms developer edition and Uninstalled express edition but I've a issue that I forget to take back up of that database.I've same data in c drive program file MS SQL ...
1
vote
0answers
21 views

verification error on importing csv file into ssms [closed]

I have a .csv file containing slightly more than a million records, and I want to import that file into SSMS 2017 but I get an error while verifying the datas as you can see in the following snapshot: ...
0
votes
1answer
42 views

Connecting to database engine again when a new query or running view

When I connect to a server via SSMS, I can connect fine albeit a slow. When I click on a new query or try to run a view in a database on this server, the same prompt comes up but with everything ...
0
votes
1answer
18 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 ...
0
votes
1answer
34 views

SSMS 2014 does not launch Graphical Execution Plan from clicking hyper-linked query plan - ShowPlanXML

I am working with an older version of Microsoft SQL Server Management Studio 2014. I run the following query: SELECT TOP 10 Q.* FROM sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_query_plan( qs....
0
votes
1answer
43 views

How to run update queries saved in a permanent table?

Permanent Table Name: PermaTable1 Values: Question is how to execute all update commands inside the table PermaTable1? This is my query but it does not execute the update command. DECLARE @Query1 ...
0
votes
1answer
25 views

Azure SQL - Setting up permissions for users

I'm busy playing around within Azure SQL and have setup replication from my on-prem DB to the Azure DB for some reporting. I would like to ensure as part of this we setup the security correctly. In ...
0
votes
0answers
15 views

How to remove the red squiggly line from IntelliSense for Queues

I know you can force SQL Server Management Studio to update the IntelliSense cache, but the red squiggly line for Service Broker Queues does not go away by updating the cache. It's not a big deal, but ...
3
votes
1answer
111 views

Available space differs between sys.database_files and database properties dialog in SQL Server Management Studio

I am looking at this for a few minutes now and could not find a thread mentioning this. I wanted to query currently used space and available space from a database on SQL Server. The numbers I query ...
1
vote
2answers
35 views

MS SQL Server create user who can access only those databases which they have created

How to create and give permission to a user in such a way that they will have full access only to the database(s) they have created not other database(s). I am using SQL Server 2016 Express.
0
votes
1answer
26 views

Line breaks handled inconsistently by SSMS

Probably more of a SQL Management Studio question than SQL, per se, but when I run the following simple query: SELECT results = 'Foo' + CHAR(13) + CHAR(10) + 'Bar' I appear to get different results ...
1
vote
0answers
15 views

Error while trying to process dimension in SSAS

I am getting the below error when I try to process my dimension in Analysis services from SQL Server Management Studio. Errors in the OLAP storage engine: The attribute key cannot be found when ...
1
vote
1answer
23 views

SQL Server 2016 - Disparity Between View Definition and View Design

I've run into an interesting issue with some databases I've inherited, and could use some help unpacking it all. The Issue After adding a column to a table, views selecting * from that table are now ...
1
vote
1answer
33 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. ...
0
votes
0answers
10 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
1answer
56 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 ...
1
vote
0answers
15 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) ...
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
40 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
13 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 ...
0
votes
0answers
51 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
77 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 ...
0
votes
1answer
21 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
50 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 ...
1
vote
1answer
58 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
15 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
22 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
1answer
19 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
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 ...
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 ...
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
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-...
2
votes
1answer
45 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
0answers
49 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
54 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
40 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 ...
1
vote
0answers
52 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 ...
0
votes
2answers
65 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 ...
1
vote
1answer
87 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??