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
56
votes
5 answers

Does the Poor Mans T-SQL formatting add-in for Management Studio 2012 work in Management Studio 2014?

Does the Poor Mans T-SQL formatting add-in for Management Studio 2012 work in Management Studio 2014? In SSMS 2012, if I go to tools, it showed up in the list. In SSMS 2014, it doesn't. I tried to run the installer again, and it gave me options to…
Hoppe
  • 6,508
  • 17
  • 60
  • 114
19
votes
5 answers

SQL Server Management Studio dark theme for whole program

Is it possible to set the SSMS theme to all dark? I really like the dark theme in Visual Studio and SSMS is built on top of the VS shell. I saw this SQL Server Management Studio Skin / Appearance / Layout, but it is only for the query editor.
J Atkin
  • 3,080
  • 2
  • 19
  • 33
18
votes
4 answers

SSMS Snippets and Shortcuts

I'm using SSMS 2014. I am able to insert a snippet but they don't seem to respond to shortcuts (ie crproc[tab]) Is this feature known to work?
recursive_acronym
  • 2,981
  • 6
  • 40
  • 59
16
votes
2 answers

SSMS 2014 randomly starts throwing "Value does not fall within the expected range" when using backspace key

Randomly when writing SQL queries in SSMS 2014, I'll get a popup that "Visual Studio has encountered an exception. This may be caused by an extension" along with a tip that I can run the application with the /log parameter and check the…
Elaskanator
  • 1,135
  • 10
  • 28
12
votes
6 answers

SSMS Export Query Results to Excel or CSV

I am trying to export the results of a query to CSV and then ultimately Excel. My issue is, one of my columns has commas in it and the commas interrupt Excel parsing the CSV in the correct places. I don't have write privileges to the db, so…
Joshua Wieczorek
  • 655
  • 2
  • 9
  • 23
12
votes
1 answer

Unable to find Restore Database Option in SSMS

I am trying to restore a .bak file in my SQL Server using SSMS. However I am unable to find the Restore Database option in the menu bar, when I right-clicked on Database. What can be the possible reason for that? Do I need to change some SSMS…
Pratik Bhattacharya
  • 3,596
  • 2
  • 32
  • 60
8
votes
3 answers

How to add custom SP calls to SSMS toolbar

Recently I've found out, that there's an option to include most commonly used queries to be executed by clicking a button on SSMS toolbar. You can do that by following these steps: Right mouse click on toolbar Click Customize Create new…
Evaldas Buinauskas
  • 13,739
  • 11
  • 55
  • 107
8
votes
1 answer

Is it normal for the Delete key not to work when trying to rename a DB/table in SSMS?

I try to rename a database or a table in SSMS 2014 (with CU6 applied), by clicking and selecting the DB or table in the Object Explorer and then pressing F2 to edit the name. The Delete key on my keyboard will not delete the character to the right…
Michael Goldshteyn
  • 71,784
  • 24
  • 131
  • 181
7
votes
1 answer

Porting Visual Studio VSPackage to SSMS 2012 or 2014

I recently discovered an extension for visual studio that allows you to specify a watermark for the code window. This extension can be found on github here. https://github.com/nategreenwood/VSEditorBackgroundChangerExtension As part of a small…
RThomas
  • 10,702
  • 2
  • 48
  • 61
7
votes
3 answers

Export Data-tier application error

I am trying to export a rather simple database using the Export Data-tier application and keep getting the following error: One or more unsupported elements were found in the schema used as part of a data package. Error SQL71564: The element…
physics90
  • 946
  • 3
  • 9
  • 24
6
votes
4 answers

alternatives to using IN clause

I am running the below query: SELECT ReceiptVoucherId, VoucherId, ReceiptId, rvtransactionAmount, AmountUsed, TransactionTypeId FROM [Scratch].[dbo].[LoyaltyVoucherTransactionDetails] WHERE VoucherId IN …
PIPRON79
  • 131
  • 1
  • 1
  • 11
6
votes
1 answer

Visual Studio 2013 High DPI workaround causes debugger to fail

Similar to this question Visual Studio 2013 High DPI on 4k Screen to which I had posted an answer but have now removed since uncovering the issue below. I too have just bought a new 4K laptop and have been having problems with high DPI with the…
Liesel
  • 2,929
  • 2
  • 12
  • 18
4
votes
1 answer

Pass temp table to EXEC sp_executesql

How can I pass temp table (@table) to EXEC sp_executesql @query set @query = 'SELECT GsName, ' + @cols + ' from ( select GSName, [THour], NumOfTransactions from @table ) x pivot ( …
Ran
  • 65
  • 1
  • 7
4
votes
1 answer

SSMS Syntax Highlighter Support for Lead and Lag

I'm currently using SQL Server Management Studio 2014, and even though LEAD and LAG have both been part of SQL Server since 2012, they still do not (by default) have any syntax highlighting (see below): Is there any way to add these functions to…
Siyual
  • 16,415
  • 8
  • 44
  • 58
4
votes
1 answer

SQL Server Management Studio 2014: Unable to view stored procedures on Azure SQL Database V12

I have updated SQL Server Management Studio to the latest version at time of writing - 12.0.4432.0 - this is SP1 with CU3 and additional bug fixes. My Azur SQL Database version is 12.0.2000.8 I can not view any stored procedures through the GUI,…
Ryan
  • 43
  • 1
  • 7
1
2 3
…
13 14