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.
Questions tagged [ssms-2016]
172 questions
4
votes
1 answer
SSMS Scripting Options
Scripting a function using SSMS 18.0 Preview 6 produces the following script.
/****** Object: UserDefinedFunction [dbo].[sfn_Proper_Case] Script Date: 7/13/2019 9:57:36 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS…
AeyJey
- 2,111
- 2
- 14
- 21
4
votes
2 answers
JetBrains DataGrip - Azure SQL - connect with Active Directory - Password
Is it possible to connect to Azure SQL database the same way as I would with Microsoft SQL Management Studio - the "Active Directory - Password" option.
I followed the instructions from here (JetBrains documentation) but when I select "Use Windows…
Jakub Holovsky
- 6,543
- 10
- 54
- 98
4
votes
5 answers
Couldn't install SSMS: A pending restart is blocking setup from completing
SSMS version : 17.7
Log file: Log_file
I have SQL Server 2016 and Visual Studio 2017 Community Edition.
I tried reinstalling both tools but the error is still the same.
Some links mention registry values and I tried that as well, but the problem…
Vivek
- 397
- 6
- 17
4
votes
2 answers
SSMS 2016: Exporting query results in CSV where fields are enclosed into delimiting quotes.
I have a missing option quote strings containing list separators when saving .csv results in SSMS 2016. Seems like this option was eliminated in this version of SSMS.
I need to export query results in CSV file (i.e., Comma Separated Variable file)…
Kaur
- 491
- 2
- 7
- 19
4
votes
2 answers
"Create new table" is not visible on SSMS 2016 for SQL Server 2008
I have a shared hosting. I was happy with it. I was creating new databases on its panel and then I was managing my databases with SQL Server Management Studio. I could add new table by right clicking the database with designer.
Database is: SQL…
oneNiceFriend
- 6,691
- 7
- 29
- 39
4
votes
1 answer
Trying to install adventureworks 2016 database
I am a newbie when it comes to sql server, and I am trying to install adventureworks 2016. I clicked on restoring databases, but I cannot find the .bak files, even though I have saved them. Do I need to save the .bak files in a specific place? And…
Zohra Tabassum
- 105
- 1
- 8
4
votes
3 answers
SQL Server Management Studio 2016 → Activity monitor → Show execution plan
I have a problem when I want to see the execution plan of an expensive recent query. The problem is that the result is displayed in XML and not as a design over the execution plan.
Does anyone know how to fix this?
Victor Öhrström
- 242
- 1
- 17
3
votes
2 answers
Is there a way to check Which Queries are run by a User in SSAS Tabular?
I am using a BI Model that is a based on SSAS Tabular, using SQL server 2016. Multiple team members are querying it for their needs. I want to find out what Queries are being run and who is running those queries.
Couldn't find DMVs very helpful in…
Njk
- 41
- 1
- 6
3
votes
6 answers
What can I use in a SQL query to help me determine why my query is not returning any data results
Can someone assist me in troubleshooting my SQL query to discover why it's not returning any results, only the column aliases?
I've broken it apart, and all sections that obviously group together returns the expected data individually. Thanks for…
suffa
- 3,606
- 8
- 46
- 66
3
votes
1 answer
Performance issues while querying a view on SQL Server
I am currently running into some bad performance issues with a strange behaviour on SQL Server 2016 Enterprise.
I created a new schema in a database and then I created a view inside this schema.
Now, when I connect directly to the database, that…
Stefan Corsten
- 33
- 6
3
votes
2 answers
Collapse/Expand Code Blocks
In Microsoft SQL Server Management Studio 2016, how do i generate the "-" and "+" (like image below) to collapse/expand code blocks?
Luca Rusin
- 81
- 1
- 10
3
votes
1 answer
Subquery returned more than 1 value in SSMS 2016
I have a database created in SQL Server 2014 x64 express edition with SSMS 2014 and have some table in the database. I backup the database with this tsql
BACKUP DATABASE dbFile
TO DISK='D:\dbFile_170125.bak' WITH FORMAT;
In other computer, i have…
Liudi Wijaya
- 898
- 2
- 8
- 24
3
votes
1 answer
SQL Server 2016 Management Studio doesn't keep line numbers
I can't get SQL Server 2016 Management Studio to remember that I want line numbers. Every time I open an instance, I have to turn line numbers on, but when I open a new instance, they've been turned off again.
Does anyone know how to make them stay…
Tony Barnett
- 29
- 6
3
votes
3 answers
SQL Server 2016 Express Management Studio cannot design a new or existing table
In Microsoft SQL Server 2016 Express Management Studio (July 2016) cannot design a new or existing table.
Image 1: click on the tables node. Where is the menu option to add a new table?
Image 2: Click on existing table. Where is the menu option to…
JaimeCamargo
- 353
- 1
- 3
- 14
2
votes
3 answers
How to copy SSMS connections in dropdown to a new computer?
I'm getting an upgraded laptop at work and my old machine had SSMS 17.9 with several dozen dbengine connections with pwds in the dropdown for dbengine Connection.
Are these in the registry, ini file, Windows Credential manager? I would like to…
jimo3
- 408
- 1
- 5
- 17