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
0
votes
1 answer
Making SQL Server Management Studio use SQL Server 2016 instead of 2012
I was recently using SQL Server 2012 which was connected properly with my SSMS (SQL Server Management Studio). Then I downloaded SQL Server 2016 yesterday and installed it.
Problem is, when I run SSMS, it opens up SQL Server 2012 instead of 2016.…
Timothy Macharia
- 2,641
- 1
- 20
- 27
0
votes
0 answers
SSMS/SQL-Express - edit user - password field is missing
I'm having a strange problem with the Microsoft SQL Server Management Studio, logged in as Administrator on an SQL Server Express-Server 13. When I want to create or edit an database-user the password-fields are missing (see screenshot). As I saw…
cklm
- 787
- 1
- 6
- 24
0
votes
1 answer
Show executed query in Microsoft SQL Server 2016
In MySQL Workbench, after editing a column, table, or whatever, it will show the query for that action.
I could not find a similar feature in SQL Server 2016. I just want to view the SQL for the action I perform, such as editing a column.
Is it…
Charles
- 151
- 2
- 13
0
votes
2 answers
Applying Quotes Across Multiple Lines in SSMS
Is there a keyboard function that applies single quotes across a list of values? I have 10 IDs that I have copied from an Excel spreadsheet and I would like to execute a query that uses an IN clause on this list, and I don't want to manually add…
Sreedhar Chintakunta
- 145
- 2
- 15
0
votes
0 answers
Is there a way to make SSMS's Import Data create the primary keys and identity specs?
I am using SSMS 2016 and the import data functionality doesn't create the primary key and identity specs in the destination tables. Does SSMS 2016 support creating these? I am importing tens of tables so per table setting is not feasible. I am…
Tony_Henrich
- 42,411
- 75
- 239
- 374
0
votes
1 answer
SQL Server Management Studio 16.4.1 - Will not run
Yesterday I updated SSMS from 16.3 to 16.4.1, rebooted and then installed the Window 10 Anniversary Update from Windows update. Everything on my PC seemed to be running fine.
However, trying to open SSMS today for the first time since the update and…
Dan Def
- 1,836
- 2
- 21
- 39
0
votes
1 answer
add Context menu in object explorer for SSMS 2016
Im trying to rewrite our addin for SSMS 2014 to an extension for SSMS 2016.
I can't seem to find a way to add a menu or command to the context menu of the object explorer.
On the Microsoft website I can find lots of id's for all the windows…
Ylluks
- 1
- 2
0
votes
1 answer
permission error on processing sql Analysis Service database cube from job agent from sql database engie(ssms)
I have an Analysis Service database which I want to process it's cube regularly using sql database engine JobAgent, I scripted my cube process and paste it as step for job and continue it's configuration exactly as written in…
Code_Worm
- 4,069
- 2
- 30
- 35
-1
votes
1 answer
SQL server find previous sales based on previous draw for the same day
I have below dataset
I'm looking for an SQL server query to get below output that will calculate previous sales based on previous draw number for the same day
Pravesh Loto
- 9
- 4
-1
votes
2 answers
Unable to access Azure SQL Server from my Azure VM SSMS
I'm getting the message when I attempt to access the my SQL Server from SSMS
Cannot connect to xxxxxxxxxx.database.windows.net.
Cannot open server 'xxxxxxxx' requested by the login. Client is not allowed to access the server. (Microsoft SQL Server,…
Patterson
- 1,927
- 1
- 19
- 56
-1
votes
4 answers
Trying to look up records based on a join
I'm trying to work on a stored procedure that is somewhat tricky, let's say I have Table_1 with this data:
Num1 Name1 Code1 Desc
-------------------------------------------
123B Apple 10 Text1
123B …
Koosh
- 876
- 13
- 26
-1
votes
1 answer
Make a master record out of several duplicate records for each id
My table structure is as shown below
Id | Name | City | Country | State
01 | Bob | *NY* | null | null
01 | Bob | null | *US* | null
01 | Bob | null | null | *AL*
02 | Roy | *LA* | null | null
02 | Roy | null | *IN* …
Salva
- 81
- 1
- 9
-1
votes
4 answers
convert time from 1530 into 3:30 PM Time Format SQL Server
Trying to convert time from 1530 into 3:30 PM time format in SQL server.
Times = 1530
I have tried:
convert(time,LEFT(Times,2)+':'+right(Times,2))
Results: 15:30:00.0000000
But it is in 24 Hrs, I want to convert into 3:30 PM. And Remove…
Tarak Pandya
- 29
- 5
-1
votes
1 answer
How to get the Total Pay per trip for each Carrier using a SQL View
I am trying to get this SQL view to total the carrier's pay. I add the Select statement right about the FROM on the top select and the union select, but what it is doing is totaling ALL carriers pay and displaying that amount on every row in the…
M Daniel
- 3
- 4
-1
votes
1 answer
Combining Updates on Table Variable
If it's possible, I would like to know how to combine the two UPDATE statements and whether this would save performance. Query currently executes in 3 seconds but will continue to grow.
Bonus points if you know of neater, more elegant filtering in…
Graham Eckel
- 16
- 5