Microsoft SQL Server Management Studio 2017 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 2017.
Questions tagged [ssms-2017]
188 questions
3
votes
2 answers
Group tables by schema in ADS
In Visual Studio's Server Explorer window there's a very nice feature that lets you see the DB objects grouped by schema:
It turns this object tree:
Data Connections -> MyServer -> MySchema.MyTable
Into this one:
Data Connections -> MyServer ->…
RaG
- 317
- 7
- 19
3
votes
1 answer
Vertical tab in SQL Server Management Studio - query and results side by side?
Does anyone know how to get the query on one side and the results on the other?
By default, the results are under the query script. I see how to use the vertical tab to get two scripts side by side, but the results are still stuck underneath. When…
Chuck
- 1,061
- 1
- 20
- 45
3
votes
3 answers
Select statement return if there is a value and if there is no value
Here's my code of the SQL Server stored procedure:
SELECT NOTES as DeletionNote
FROM STCRCHF_LOG
WHERE STHTR_ = @transferNo
IF ( @@ROWCOUNT = 0)
If there is data found, I just want to return the string of NOTES. Else if it doesn't have data, I…
Raven Supilanas
- 81
- 7
3
votes
1 answer
Properties option doesn't show in SSMS for Azure DB
I am trying to create a full-text search mechanism, to do that I created full text catalog in my local database. Then I opened context menu and it had properties option.
I opened it and set up tables/views tracking. But when I tried to do the same…
IAmVisco
- 373
- 5
- 14
3
votes
2 answers
Import data tier application is failing
I'm getting the following error while restoring the database backup (.bacpac file) into my on premise SQL Server 2016 instance.
TITLE: Microsoft SQL Server Management Studio
Could not import package.
Warning SQL72012: The object [Azure_Data]…
Jesalcv
- 447
- 1
- 5
- 17
2
votes
2 answers
How do I select records into a single row?
I've tried writing my sql query to select multiple records on to one row but it isn't working the way I expected it to
Currently my table looks something like this
person…
Emmanuel Natera
- 31
- 3
2
votes
0 answers
Why does SSMS intellisense falsely flag linked server query?
I am using SSMS 2017 on a SQL Server 2014 database. I can query a linked server with no problem. I'm redacting the actual names, but this should give you an idea of my query statement.
SELECT *
FROM…
RandomHandle
- 641
- 7
- 25
2
votes
1 answer
How to filter a specific record in SQL Server within in the date range without removing other records?
I am using SSMS 2017.
Below is a source table,
from the above table I want to filter only 'i' records
in which the date difference is >=6 months by satisfying the following condition (date2 <= dateadd(MONTH, +6, date1 - datepart(MONTH, date1)…
Nani
- 69
- 1
- 7
2
votes
3 answers
How to pivot without knowing fixed columns in T-SQL
I have a table called balance which I wish to pivot, however it is quite difficult since the column names would be labelled 1,2,3 and balances would be sorted by descending order per customer.
This is screenshot of current table:
And the pivot…
JasonX
- 105
- 9
2
votes
1 answer
Switch from SQL Server Express to SQL Server Developer edition on the same computer
My computer has at least 3 installations of SQL Server:
SQL Server 2017 64 bits for the Express edition. I can connect with SSMS with localhost\SQLEXPRESS. Version is 14.0.1000
SQL Server 2017 Developer Edition. I can connect with SSMS with…
Nolmë Informatique
- 612
- 6
- 13
2
votes
4 answers
Error when trying to install SSMS 18.4 version
Not sure if anyone has came across this problem but any help is greatly appreciated.
I have SSMS 18.0 Preview 4 installed on my local machine. Whenever I am trying to install any new released version of SSMS I get below error.
Error: The…
SQLLogic
- 31
- 1
- 7
2
votes
0 answers
Microsoft SQL Server Management Studio 17: The application cannot start
After reinstalling the Visual Studio Professional 2017, since then
I used to get the error message as The application cannot start, while opening the Microsoft SQL Server Management Studio 17
I had repaired and reinstalled but still the problem…
Nɪsʜᴀɴᴛʜ ॐ
- 2,756
- 4
- 33
- 57
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
2
votes
2 answers
How to re-run the query in the SQL Server Management Studio "Edit Top ### Rows" window
I am editing a table row in SSMS, and when the row committed, it appeared tan-colored instead of black with a red exclamation mark indicating that there was a problem attempting to get the data back after the row committed.
It says to re-run the…
rory.ap
- 34,009
- 10
- 83
- 174
2
votes
1 answer
Shortcut for OK button in SSMS filter dialog
What is the shortcut for OK button in SSMS filter dialog? When I filter tables I have this dialog box. After typing MyPhrase in Name field when I hit Enter key the cursor goes down to next field Schema. I want to use keyboard to hit OK instead of go…
Przemyslaw Remin
- 6,276
- 25
- 113
- 191