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
2
votes
2 answers

SQL Server Management Studio reset all styles

So I messed up my sql server management studio when I was trying to make it have a "dark theme" as I use it a lot and it was starting to wear on my eyes. While doing this, I specified for the output window to have a black background with white text.…
Ryan
  • 970
  • 15
  • 36
2
votes
1 answer

Database Diagram not showing table relation when new foreign key reference is added in SSMS 20114

I have three tables as follows - But when I add the foreign key reference, the relation is ( a straight line in the Database Diagram) not shown. Following is the reference I wrote. ALTER TABLE [dbo].EmployeeDesignation ADD CONSTRAINT…
Dastagir Husain Yasin
  • 382
  • 4
  • 15
2
votes
4 answers

Sql Select top 3 per rollup group

How do I return only the top 3 values per Name-datee pair in the following? DECLARE @t TABLE(NAME NVARCHAR(MAX),datee date,val money) insert INTO @t SELECT 'a','2012-01-02',100 insert INTO @t SELECT 'a','2012-01-02',100 insert INTO @t SELECT…
conor
  • 1,204
  • 1
  • 18
  • 22
2
votes
3 answers

Select into statement in a view

I want make a view of a select statement that uses a temp table but I am getting errors about views may not have temp tables. How can I resolve this? This is my query CREATE VIEW vwTopStackedItems AS SELECT COUNT(INVENTORY.itemID) as Stacks,…
Tristan
  • 83
  • 1
  • 8
2
votes
1 answer

Index GUI Issues with SSMS 2014 and 2016 when working with SQL Server 2005

We currently work with all versions of SQL Server from 2005 onwards. To save time I try to do everything in a single version of Management Studio. This also helps if running newer client operating systems like Windows 10 which old client tools…
Paul Andrew
  • 3,233
  • 2
  • 17
  • 37
2
votes
1 answer

Excel VBA - SQL Call - Operation is not allowed when the object is closed

I have a couple macros to make calls to SSMS 2014 to run a query and return the results in a defined cell in my worksheet. They work successfully, but when I try to use certain queries with temp tables I get the following error message: I have…
TheGuyThatDoesn'tKnowMuch
  • 1,240
  • 1
  • 17
  • 28
2
votes
2 answers

Cant connect to the Azure SQL Database

For the past month I have been using Microsoft SQL Server Management Studio tool to connect to my database which created on the Azure portal. Recently I received updates from Microsoft related to Microsoft Visual Studio. After I installed these, I…
Senthil Kumar
  • 21
  • 3
2
votes
1 answer

Intellisense does not work

I recently installed MS SQL Server Mgmt. Studio 2014 and discovered Intellisense was not working at all even though it was enabled by default. What's interesting is that the icon on the toolbar to disable/enable Intellisense is grayed out so that I…
Sung
  • 211
  • 3
  • 15
2
votes
2 answers

SSMS 2014 - Failed to retrieve data for this request - unknown property IsMemoryOptimized

I get the following error when I try to expand keys for a table using SSMS 2014 on Azure SQL Server (13.0.702). If I use "Script Table as" I can get a working query. Has anyone else experienced this? Error: Microsoft SQL Server Management…
Ogglas
  • 62,132
  • 37
  • 328
  • 418
2
votes
1 answer

Launching SSMS 2014 VsDebugPresentationPackage Error

I am getting this error when trying to launch SQL Server Management Studio 2014. Package VsDebugPresentationPackage did not load correctly. And in error log: SetSite failed for package [VsDebugPresentationPackage, Version=10.0.0.0, Culture=neutral,…
Yaser
  • 5,609
  • 1
  • 15
  • 27
2
votes
0 answers

SQL Server adding its own aliases and getting them wrong

I wrote the following short, simple view: --DROP VIEW ReportObjects.vStarts; CREATE VIEW ReportObjects.vStarts AS SELECT * FROM ReportObjects.vLotHistory WHERE LotType = 'Some constant value' AND CDOName = 'Some constant value' AND…
Charles Burns
  • 10,310
  • 7
  • 64
  • 81
2
votes
1 answer

Filter SSRS report to current user

This seems to be a common issue, but I could find no solution which worked. I have an SSRS report which shows employee Vacation balances. I want to make a linked report which will only display information for the current user. The built in field…
gruff
  • 411
  • 1
  • 9
  • 25
2
votes
0 answers

how can I output something to the SSMS "Messages" tab from an SSMS add-in

I'm working on an SSMS 2014 addin, and I need to output stuff to the messages tab of the active document. I know I can get that document like this : var document = ((DTE2)ServiceCache.ExtensibilityModel).ActiveDocument; but I've not been able to…
Brann
  • 31,689
  • 32
  • 113
  • 162
2
votes
2 answers

SQL Server 2008: DROP PROCEDURE error

I try to execute this command: IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.njams_test_sql_2.[PROC_CHECK_TRACE_SETTINGS]') AND type in (N'P', N'PC')) DROP PROCEDURE…
Hakan Kiyar
  • 1,199
  • 6
  • 16
  • 26
1
vote
0 answers

Call to undefined function sqlsrv_connect() when connecting Microsoft SQL management studio 2014 with php

PHP Fatal error: Uncaught Error: Call to undefined function sqlsrv_connect(). $serverName = "serverName"; $connectionInfo = array("Database" => "databaseName"); $conn = sqlsrv_connect($serverName, $connectionInfo); if ($conn) { echo "Connection…
Gowri Shankari Manohari
  • 19
  • 2
1 2
3
…
13 14