Stack Overflow
Stack Overflow

Questions tagged [ssms-2016]

Microsoft SQL Server Management Studio for SQL Server 2016 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 for SQL Server 2016.

172 questions
2
votes
1 answer

Import csv file via SSMS where text fields contain extra quotes

I'm trying to import a customer csv file via SSMS Import Wizard, file contains 1 million rows and I'm having trouble importing where the field has extra quotes e.g. the file has ben populated freehand so could contain anything. Name,…
Roger Clerkwell
  • 406
  • 4
  • 19
2
votes
2 answers

SSMS Color tab based on connection string / Environment

SQL Server - SSMS Can we change the SSMS query tab color based on connection string? Lets say I'm connecting to different environments Prod / Dev / UAT/ Test etc... or I want to group my servers based on some other criteria
singhswat
  • 832
  • 7
  • 20
2
votes
1 answer

SQL Server - Complicated sort before pivot?

This request might seem incredibly convoluted and longwinded, so apologies in advance. I have several tables: ITEM, FINAL_SORT and "another" table (in this case I will use the CARTON table, but there are other tables which require the same…
Smeghead
  • 185
  • 3
  • 12
2
votes
1 answer

Create a list with dates which are in between start and end dates

Using SQL Server 2016. I have a table with different start and end dates Start | End -----------------+----------------- 2018-01-01 00:00 | 2018-01-01 23:59 2018-01-12 05:33 | 2018-01-13 13:31 2018-01-24 22:00 | 2018-01-27 01:44 I…
Luke
  • 127
  • 1
  • 6
2
votes
1 answer

SQL Server Management Studio 2017 not showing databases that were created in SQL Server 2016

I had Express edition installed of SQL Server 2016. I needed to use SQL Agent Jobs. For that purpose I installed a patch of SQL Server 2016 enterprise edition but it didn't worked. After that I installed SQL Server 2017 Developer edition which…
Harry .Naeem
  • 1,245
  • 3
  • 20
  • 33
2
votes
0 answers

must always restart sql server when connecting with different client

After a BSOD the sql server doesn't work normal anymore. I must restart the SQL SERVER (SQLEXPRESS) service every time I'm connecting with different client (application) e.g: When I'm connecting with the software I developed it connects, then when I…
Amboara RABE-HARINORO
  • 91
  • 1
  • 8
2
votes
1 answer

How can I format my string in SQL so that it is interpreted properly in Powershell?

I'm currently working on a simple SQL Script that I want to run from SSMS. What the script is supposed to do is take a database, make a backup of it, and then make a .zip file of that backup. The problem I am running into is when attempting to zip…
user2560035
  • 701
  • 2
  • 6
  • 12
2
votes
1 answer

Compare SSMS settings

I am wanting to compare the settings of SSMS 2016 installed on two different machines is there an easy way to this instead of pulling up each setting and going through one at a time in the GUI.
Chad Portman
  • 1,134
  • 4
  • 12
  • 38
2
votes
0 answers

What are the 20 SQLEXPRESSnn users for?

I have SQL Server 2016 Express (13.0.4199.0) and my SSMS is 13.0.16106.4 I searched my PC (name Beethoven) user objects and found 20 SQLEXPRESSnn users as follows: Who are they and can they be deleted? I was actually looking for the usual…
Old Geezer
  • 14,854
  • 31
  • 111
  • 198
2
votes
2 answers

“Prevent saving changes that require the table to be re-created” Microsoft SQL Server

I was modifying a column in SQL Server 2016 Management Studio (SSMS) and got the error: The changes you have made require the following tables to be dropped and re-created I'm testing and so I don't have any problem with dropping and…
NBajanca
  • 3,544
  • 3
  • 26
  • 53
2
votes
1 answer

Is there a way to start SSMS and autoconnect to different servers?

Is there a way to start SSMS 2016 and autoconnect to different servers? So that I don't have to do this manually every time I start SSMS. An SSMS add-on?
Tony_Henrich
  • 42,411
  • 75
  • 239
  • 374
2
votes
2 answers

SSMS 2016 - Text Editor Color Settings

Anyone could help me to restore default text editor color settings in SSMS 2016? query Might it to depend from the fact that "the menu is in Italian and the buttons are in English"? (sorry for the simplification). Infact, first of all I have run…
LCap
  • 21
  • 2
2
votes
5 answers

An exception occurred while executing a transact-sql statement or batch

I keep getting the error message: an exception occurred while executing a transact-sql statement or batch when trying to do anything in SQL Server Management Studio 2016. This occurs when I try to create or edit a login, when I try to create a…
krishna
  • 163
  • 1
  • 2
  • 7
2
votes
1 answer

SQL Server Management Studio error

I am getting the following error after installing SQL Server 2016 Management Studio from https://msdn.microsoft.com/en-us/library/mt238290.aspx This is the error in activityLog.xml: 78
desiguy
  • 652
  • 2
  • 9
  • 25
2
votes
2 answers

Execution plan not showing - CTRL + L shows only number of rows affected

Sometimes when I try to get the estimated execution plan for a query, SSMS will not show any results other than (1 row(s) affected) in the messages pane and "Query executed successfully" in the status bar. If I try to run CTRL+L on parts of what I…
Geeky Guy
  • 9,229
  • 4
  • 42
  • 62
1 2
3
…
11 12