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
0
votes
1 answer
restore database in ssms 2017 selected bak file in device option and showing nothing in Backup sets to restore option and disable Ok button too
I am trying to restore sample database adventureworks in SSMS 2017
right Click in Database
selected Restore Database
in Device option then option ADD
selected AdventureWorks2017.bak file in my hard drive
c:\Microsoft SQL…
osk
- 21
- 1
- 7
0
votes
1 answer
How to convert IP address stored in a table into hexadecimal? the output I am expecting is 00:00:8D:69:DF:B6 for an IP 141.105.223.182
I used this for converting a IP address, (I read this from web not my SQL). I now want to understand how can I convert an IP address stored in a column to HEXADECIMAL.
DECLARE @IP varchar(30)
SET @IP = '192.168.1.1'
SELECT…
0
votes
2 answers
Finding lowest Ids of duplicates and updating tables according to these Ids
The problem
I have a sql database with a table for Hashtags, of which many are duplicates with regard to their names.
A statement like
SELECT *
FROM HashTag
ORDER BY Name
returns something like
Id | Name
1947 | test
1950 | …
Michael Boehnke
- 3
- 2
0
votes
1 answer
How to write a query procedure that can be send to other local machines?(Beginner)
I have the database, tables, PK's and FK's, i need to send it to the other local machine, i tried writing some query's but it failed.
(Please be polite, just started :) )
Limun
- 167
- 1
- 7
0
votes
1 answer
How to check if the row of the first column is greater than the second in sql (Using IF Statement)
I wrote a query to create a table with one column
CREATE TABLE ORDER(
Order_Date DATE NOT NULL
)
I inserted two values into the column
--Order_Date--
2018-05-21
2018-01-21
How to check if the first row is greater or less than the second row…
Israel Obanijesu
- 666
- 1
- 12
- 24
0
votes
1 answer
Retrieving latest records with specific values
What I am tryint to do is basically have a list of events. On each events there are multiple criterias and several keys. I want to retrieve the lates record of each unique key with the value that that specific row has. What I have tried:
SELECT…
Stoff
- 517
- 6
- 22
0
votes
0 answers
SSMS Timout problems
I have weird behaviour in SSMS 2017.
I am trying to run some stored procedure in SSMS and I get next message every time trying to run it:
Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is…
Ryukote
- 767
- 1
- 10
- 26
0
votes
0 answers
How do I change the size of the text in Microsoft SQL Server Management Studio 2017?
How can I change the size of the text that displays the database names and toolbars in Microsoft SQL Server Management Studio 2017 v17.4?
Dwayne Gibbs
- 58
- 7
0
votes
0 answers
SQL Server Management Studio keyboard shortcuts are not working (particularly Edit.GoToDefiniton)
I have installed SQL Serever Management Studio 17.6. There are necessary for me to use Edit.GoToDefiniton - F12 shortcut, but it does not work.
If refer to MSDN there is such shortcut, but actually no.
Yevhenii Nadtochii
- 604
- 6
- 17
0
votes
0 answers
Why there are two instances of SQL Server Management Studio and SQL Server 2017 Express?
I have recently installed SSMS 17 and SQL Server from this link: SSM Studio,
and I also installed SQL Server Express from the official site.
As on SSMS download page there are two downloads available SSM Studio 17.6 and 17.6 upgraded packages so I…
Hammas
- 1,126
- 1
- 12
- 37
0
votes
1 answer
When the value of the sub key is deleted or How to prevent the deleting - vsix
In vsix-package extension for SSMS I have problem -
after the Initialize function the value of the sub-key is deleted (in the registery edit) and it causes that if I open the SSMS several times in a row, the extension is loaded only to the first…
ron
- 1
- 6
0
votes
1 answer
How to load dll extension after SSMS 2017 finished to load
How can I load dll every time immediately after the SSMS 2017 finish to load itself
(I want to register to particular event)
If you think I need to do it with the attribute [ProvideAutoLoad] please, give me the parameters.
thank you
Ron
ron
- 1
- 6
0
votes
1 answer
Unable to change Authentication Mode in SQL Server: Microsoft SQL Server, Error: 229
I have just installed SQL Server 2016 Service Pack 1 Express and SSMS 2017 using the Basic option from the installation wizard. After installation, I wanted to change the mode of authentication from Windows Authentication to SQL Server…
user9335731
0
votes
1 answer
SSMS can't connect to remote server, crashes
I installed Microsoft SQL Server Management Studio v17.3 on a Windows 10 box. I created a Central Management Server instance and successfully connected to it.
I created a second Central Management Server instance to a different URL and the Test…
MikeJRamsey56
- 2,779
- 1
- 20
- 34
0
votes
1 answer
SSMS 2017 is not showing server name
I installed SQL server 2017 but I am not able to connect it because Server Name is not showing, its showing blank. Please suggest.
Thanks in advance.
Abhay Dixit
- 998
- 8
- 28