Stack Overflow
Stack Overflow

Questions tagged [ssms-2017]

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.

188 questions
1
vote
1 answer

SQL: Select from multiple JOINS in different subqueries

I have the two tables Employees and Assignments with contents as visible in the images below (output A and B respectively). Each employee in Employees has max. 1 project leader (Assignment.A_Leader = 1) and max. 1 project controller…
stonebe
  • 482
  • 1
  • 3
  • 14
1
vote
1 answer

while runing DQSinstaller.exe it fails with following description why?

I have installed sql server 2017 and SSMS 2017 but when i run dqsintaller.exe it fails with errors which are as follows Please help me resolve issue as i am newbie and still learning and working out how things works around [16/03/2020 4:38:38…
ETL - BI
  • 59
  • 9
1
vote
1 answer

Assign values to variables in stored procedure

select @numOfColumns = count(distinct Col) from #b SET @sql2= 'SELECT'+ @columns +'+= QUOTENAME(Col) + '','' from (SELECT DISTINCT top @numOfColumns Col FROM #b ORDER BY Col) A'; EXECUTE sp_executesql @sql2; I am trying to get this stored…
JasonX
  • 105
  • 9
1
vote
2 answers

In SQL Server Management Studio (SSMS), when using "Copy Diagram to Clipboard", how can you get it to include column names?

In SQL Server Management Studio (SSMS), right-clicking on a database diagram and choosing "Copy Diagram to Clipboard" results in a image of the diagram that is missing the table's column names. The table names, outlines of the tables, and…
VapUI49
  • 51
  • 2
  • 8
1
vote
1 answer

Why there is no Server Name under integration services in SSMS?

I cant connect to Integration Services in SSMS there is no Server Name under it when I browse , if I type manually the server name based on how other services have it says class not registered
Johnny Adams
  • 65
  • 7
1
vote
2 answers

Get the max Time in a datetime column for specific Hours in the day?

I have a column called SnapshotDate with a snapshot every 30 minutes going back two years (example of this column in link below). How do I get the max Minute (or Second) entry in the SnapshotDate for when the Hour is either 6 or 15? Note: The 30…
RohRoh
  • 15
  • 4
1
vote
1 answer

How to detect cyclical reference in SQL Server Query - SQL Server 2017

I have a recursive WITH query in SQL Server 2017: ;WITH rec AS ( SELECT col1 AS root_order ,col1 ,col2 ,col3 ,col4 ,col5 ,col6 ,col7 ,col8 ,col9 FROM TableA UNION…
artemis
  • 6,857
  • 11
  • 46
  • 99
1
vote
1 answer

Update a column in a table with all possible combinations of values within a single column in SQL

How can I update a column in a table with a value from other column for all possible combinations ? Example: COL1 | COL2 | COL3 | ClientKey | MasterKey -----+-------+-------+------------+------------ 123 | 345 | 678 | AAA | …
Kiran Mudumbi
  • 13
  • 3
1
vote
1 answer

Using Cross Apply - How to Join Tables to Cross Apply Join

How do I join back onto the value that is being returned as value from a CROSS APPLY? The below code is taking a value stored as a CSV in a single column and splitting it out to be returned as a table using STRING_SPLIT(). I simply want to JOIN…
Code Novice
  • 2,043
  • 1
  • 20
  • 44
1
vote
2 answers

How to find/see tempdb in SQL Server

Should I expect to be able to see tempdb tables in SSMS? e.g. If I run this code, should I expect to be able to see the table in SSMS? -- Drop the table if it already exists IF (SELECT OBJECT_ID('tempdb..#TempPasswords')) IS NOT NULL DROP…
Allan F
  • 2,110
  • 1
  • 24
  • 29
1
vote
0 answers

How can I get debug symbols for SSMS? (prefer 17.9.1)

All of my team are supposed to have VDIs based on the same image. Some of us (4 of 6) are having a problem. SSMS fails with the message: SSMS has stopped working Windows can try to restart the program. my options are to Restart or Debug. I…
J. Chris Compton
  • 538
  • 1
  • 6
  • 25
1
vote
0 answers

SSMS navigate with arrow keys through objects

Is it possible to navigate through SSMS Object Explorer objects using arrow keys?
Przemyslaw Remin
  • 6,276
  • 25
  • 113
  • 191
1
vote
1 answer

Copy/paste results from Cube Browser in SSMS 2017

On my SSMS 2008 R2, whenever I browse a cube through SSAS, I can easily select all my results (Ctrl+A) and copy/paste it (Ctrl+C & Ctrl+V) into a Excel spreadsheet. As so (notice how all the content gets highlighted): When I attempt the same thing…
Bob
  • 467
  • 1
  • 4
  • 13
1
vote
1 answer

Change transaction isolation level for all queries

I am connecting to an SQL Server database with SSMS 2017 to check some errors in reports, and the DBA says that when I'm running heavy queries, it blocks the outgoing processes. So the solution is to set transaction isolation level to read…
Alexandr Kapshuk
  • 1,380
  • 2
  • 13
  • 29
1
vote
1 answer

SQL - can't get to DB after canceling query

i tried to insert table from too big flat file. after few hours when it didnt finished (and eat all my drive space) i cancel the query (which also take long time). since then i cant reach all that DB tables. when i tring to expand tables' folder…
r.tom
  • 65
  • 1
  • 1
  • 8
1 2 3
…
12 13