Stack Overflow
Stack Overflow

Questions tagged [ssms-2014]

Microsoft SQL Server Management Studio 2014 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 2014.

SQL Server Management Studio 2014 is a tool included with Microsoft SQL Server 2014 for accessing, configuring, managing, administering and developing all components within Microsoft SQL Server. The tool includes both script editors and graphical tools which work with objects and features of the server.

SSMS combines the features of Enterprise Manager, Query Analyzer, and Analysis Manager, included in previous releases of SQL Server, into a single environment. In addition, SSMS works with all components of SQL Server such as Reporting Services and Integration Services. Developers get a familiar experience, and database administrators get a single comprehensive utility that combines easy-to-use graphical tools with rich scripting capabilities.

On Wikipedia: SQL Server Management Studio

206 questions
3
votes
1 answer

TSQL -- how does optimizer deal with joins with unused tables

TSQL -- how does optimizer deal with joins with unused tables SELECT table1.col1, table2.col1, table2.col2 -- etc. FROM dbo.table1 LEFT JOIN dbo.table2 on (table1.id = table2.id) LEFT JOIN dbo.table3 on (table1.id = table3.id) In the simple…
JosephDoggie
  • 1,514
  • 4
  • 27
  • 57
3
votes
3 answers

SQL server how to change pipe separated column string to rows

I have 3 columns in a table, in which 2 columns have string separated by a '|' pipe. Both these columns values depend on each other. For an example: I have data in the table like this : ID product quantity 1 A|B|C 1|2|3 2 X|Y|Z 7|8|9 I…
user3423920
  • 189
  • 1
  • 4
  • 13
3
votes
3 answers

Connecting a Multi User Access Front End to SQL Server Back End

Thank you for your help as always! I have built an Access database that we intend to distribute to ~100 end users. I am currently running a pilot program for 5 users. I have migrated the tables to SQL 2014 Server but currently the back end of the…
Chuck0185
  • 531
  • 3
  • 15
  • 36
3
votes
1 answer

Subquery returned more than 1 value in SSMS 2016

I have a database created in SQL Server 2014 x64 express edition with SSMS 2014 and have some table in the database. I backup the database with this tsql BACKUP DATABASE dbFile TO DISK='D:\dbFile_170125.bak' WITH FORMAT; In other computer, i have…
Liudi Wijaya
  • 898
  • 2
  • 8
  • 24
3
votes
2 answers

How to determine which query is more efficient in SSMS 2014

With SSMS, how can I determine which query is more efficient? I prefer A, but I am told that the subquery is executed once for each row in Transmission, and thus B is preferred. A Update t set t.transmission_status_id = (select…
Greg Gum
  • 33,478
  • 39
  • 162
  • 233
3
votes
2 answers

Installing SSMS 2014 giving error of DLL required

I'm installing SSMS 2014 but while installing I'm getting below error:- "There is a problem with this Windows Installer package. A DLL required for this installation to complete could not be run. Contact your support personnel or package…
agm92
  • 314
  • 1
  • 3
  • 11
2
votes
2 answers

SSMS Color tab based on connection string / Environment

SQL Server - SSMS Can we change the SSMS query tab color based on connection string? Lets say I'm connecting to different environments Prod / Dev / UAT/ Test etc... or I want to group my servers based on some other criteria
singhswat
  • 832
  • 7
  • 20
2
votes
0 answers

Can't change the language of SSMS to English

The option "Use the language of Microsoft Windows" in "International Settings" is chosen: And the Windows language is English, as seen here: Other solutions I have also tried completely deleting the German Version and Reinstalling the English…
Sk83r1l4m4
  • 153
  • 11
2
votes
1 answer

How to Combine to values into datetime

How to combine two values into a datetime field Example value 1 = 2010-10-26 00:00:00.000 (datetime) Example value 2 = 1650 (varchar) Desire Result 2010-10-26 16:50:00.00
Jason312
  • 197
  • 1
  • 1
  • 10
2
votes
2 answers

Change Background color of NULLs in SSMS 2014

I would like to change the background colour of NULL values(to Yellow or some other) in Management Studio results Grid but cannot find a way to change it. Currently it just displays a white background similar to other cells. Any help is highly…
SQLGuy2012
  • 51
  • 1
  • 3
2
votes
1 answer

Finding the right SQL report

I know that I've used it before but I cannot find it now. I have several SQL Server Agent jobs that run. Some of them fail, but the error messages in the History are not very helpful. I found a report that helped, but now I cannot remember where I…
Mike
  • 1,853
  • 3
  • 45
  • 75
2
votes
1 answer

Stored procedure with optional parameter that doesn't show in SQL Server Management Studio "execute stored procedure" or "script stored procedure"

In SQL Server Management Studio (SSMS), you can execute a stored procedure using the GUI for assistance. This can done by right-clicking on the stored procedure in the Object Explorer and selecting either "Execute Stored Procedure" or "Script…
rory.ap
  • 34,009
  • 10
  • 83
  • 174
2
votes
3 answers

Is there a shortcut to deleting all in one table not in another?

Are there any shortcuts for deleting everything in one table that does not exist in the second? I know I can do this: DECLARE @Table1 TABLE (ID INT) DECLARE @Table2 TABLE (ID INT) INSERT INTO @Table1 VALUES (1),(2),(3),(4) INSERT…
DaveX
  • 745
  • 6
  • 16
2
votes
1 answer

SQL/SSMS - partial data move from one table to another with two conditions

Ok...I've looked around and haven't found anything that helps me resolve my specific issue. I have a table with contents that I am trying to move (table1) to an existing table (table2) into newly created columns. table1: CNTC_COMM_TYP_ID …
Matt Jackson
  • 158
  • 9
2
votes
1 answer

SQL Azure V12 BACPAC import error: "The internal target platform type SqlAzureV12DatabaseSchemaProvider does not support schema file version '3.5'."

Today, Jan. 20, 2017, I created a BACPAC file from a SQL Azure V12 database, and when I went to import it to a local SQL Server 2014 instance using SQL Server Management Studio 2014, I got this error: The internal target platform type…
Gyromite
  • 769
  • 6
  • 16
1
2
3
…
13 14