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
31
votes
4 answers
SSMS 2016 Error Importing Azure SQL v12 bacpac: master keys without password not supported
I have done this dozens of times but just recently ran into this error. Here are the steps I have gone through to get here:
Create a copy of my Azure SQL v12 database on the same server as the original
Export the copy-version (completely inactive…
How 'bout a Fresca
- 2,267
- 1
- 15
- 26
28
votes
2 answers
Is there a way to view whitespace in SQL Server Management Studio 2016?
It doesn't look to me like there's any menu option which enables whitespace to be viewed in the text editor.
There's a similar question here, however this is referring to SSMS Express 2005 . An answer to this question shows how whitespace viewing…
DNKROZ
- 2,634
- 4
- 25
- 43
16
votes
3 answers
System.OutOfMemoryException occurs frequently after Upgrading SQL Server 2016 to version 13.0.15700.28
I am running Windows 10 Pro 64 bit on a dev box that has multiple monitors, 16 gigs DDR4 RAM, 4 Ghz I7, GTX 970. I run SQL Management Studio with SQL Server 2016 Developer Edition along with VS 2015 Enterprise Update 3.
Yesterday I upgraded Sql…
djangojazz
- 14,131
- 10
- 56
- 94
12
votes
1 answer
A valid destination folder for the install could not be determined when installing SQL Server Management Studio 2016
Whilst installing SSMS 2016, I get the following error and setup terminates:
SQL Server 2016 Common Files: A valid destination folder for the install could not be determined.
I've tried the following solutions:
Delete all files in %TEMP%…
Ivan-Mark Debono
- 15,500
- 29
- 132
- 263
8
votes
3 answers
How to add custom SP calls to SSMS toolbar
Recently I've found out, that there's an option to include most commonly used queries to be executed by clicking a button on SSMS toolbar.
You can do that by following these steps:
Right mouse click on toolbar
Click Customize
Create new…
Evaldas Buinauskas
- 13,739
- 11
- 55
- 107
6
votes
1 answer
SSMS : Unable to show XML in the SSMS Explorer
We are getting below error msg in the pop-up windows, when trying to view the generated XML in SSMS - Sql Server.
Microsoft SQL Server Management Studio
Unable to show XML. The following error happened: Unexpected end of
file while parsing Name…
RP-
- 61
- 1
- 4
6
votes
2 answers
How to update SQL addins to work in SSMS 2016?
Years ago I wrote an addin to do specific things I want in SSMS. I use it all the time and have gone through the pain of working out how to get it running again each time a new version of SQL server breaks the addin model.
I've now installed SSMS…
Reg Edit
- 6,719
- 1
- 35
- 46
6
votes
7 answers
SSMS stopped loading my stored procedures after update
Today I installed version 13.0.15800.18 of Microsoft SQL Server Management Studio (SSMS) [2016-09-20, 16.4], and now it refuses to edit my stored procedures. I even tried a slightly older version on my other computer to make sure, and they open just…
Michael
- 2,268
- 20
- 24
6
votes
1 answer
Using regex replace in SSMS 2016 to trim lines
How can I use SSMS 2016 regex replace feature to remove extra spaces and tabs at the end of lines?
Example of editor content:
select
'tab'
, 'space'
select
'tabs'
, 'spaces'
Goal:
select
'tab'
, 'space'
select
…
jumxozizi
- 642
- 10
- 21
5
votes
2 answers
Could not find stored procedure 'sp_msforeachtable' while looping through server for stats (SSMS)
I've written this to loop through each database on a server, collecting the statistics for each table and storing them in a temp table. Eventually, I'll integrate this into a more permanent structure, but for now I'm just trying to get this working.…
Joe G
- 53
- 1
- 4
5
votes
2 answers
#Errors in SSMS built-in reports
From my local computer I am using SQL Server 2016 Management Studio client (SSMS) to connect to a SQL Server installed on a remote computer. I connect using Windows Authentication method.
My SQL Server Management Studio 2016 installed in my local…
Willy
- 9,848
- 22
- 141
- 284
5
votes
1 answer
SSMS 2016 - Mobile reports - creating custom control
Is it possible to create Custom (own) controls for the SQL Server Mobile Report publisher? Meaning own graphes (Gauges), styles, maps, etc...
I was unable to find any information about this topic on Google (or other sites like SO). Few days back we…
Tatranskymedved
- 4,194
- 3
- 21
- 47
5
votes
1 answer
How to enable local (i.e. offline) help in SSMS 2016?
Let's have simple
SELECT 'a'
Whenever I press F1 on SELECT keyword, standalone installed SSMS 2016 launches web browser to display online help.
I want F1 to open local help for SELECT keyword.
What I have done so far:
Menu Help > Add or Remove…
miroxlav
- 11,796
- 5
- 58
- 99
4
votes
1 answer
Import CSV (flat file) using SQL Server Management Studio in existing table
May someone please let me know if there is a way to import CSV files in an existing table using SQL Server Management Studio GUI
I tried the below but this method always creates a new table and will not allow importing in an existing table:
*Right…
M-A Charlotte
- 325
- 1
- 3
- 10
4
votes
1 answer
Unable to update COMPATIBILITY_LEVEL of database in ssms 2016
While deploying the database on the Azure server, I get an error as:
The database compatibility level '15' is not within the supported
range of 80 to 130. (Microsoft.SqlServer.Dac)
I tried updating the COMPATIBILITY_LEVEL by the below…
Deva
- 1,039
- 1
- 14
- 40