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
0
votes
1 answer

Can't find my snippets in ctrl K/X in SSMS

I imported them in this windows : https://i.stack.imgur.com/sl2EC.jpg but I can't find them in : https://i.stack.imgur.com/d6P2l.jpg Any idea why ? It's a fresh install of SSMS (and windows). Worked before.
LemonCat
  • 35
  • 1
  • 9
0
votes
2 answers

How to get a table's current identity value using SSMS?

I'd like to know if there's a way to get the value of the identity for a table with SSMS. I expected to find it in the Design view of the table, but I can't find it there. To clarify things up: This must be done with SSMS's UI only, not a query…
ispiro
  • 26,556
  • 38
  • 136
  • 291
0
votes
1 answer

Add catalog to remote ssis

First of all I am new to ssis so sorry if this question is simple to answer. I open sql management studio 2014, and connect to my sqlserver. Secondly I connect to my integration services. Now I have an .ispac file that needs a catalog in my…
el shorty
  • 237
  • 2
  • 5
  • 14
0
votes
1 answer

unable to access case statement output from outer query.

I am trying to execute the following query in SSMS 2014. However, I am unable to access from the outer query, the column created using a case statement in the inner query. i.e.I am not able to access c.current. Error obtained - Incorrect syntax…
stackuser
  • 672
  • 1
  • 9
  • 21
0
votes
1 answer

Connect different Windows User in SQL Server Management Studio (Windows 10)

In Windows 7, I used the following method to connect to a SQL server with a different domain/user: runas /netonly /user:domain\username program.exe Source: Connect different Windows User in SQL Server Management Studio (2005 or later) However, this…
erwinvk
  • 1
  • 2
0
votes
1 answer

How do I get a FOR XML AUTO result to be more than 256 characters from SSMS?

I've found various solutions to this issue but they don't seem to work. I have a query that returns a single result that has about 6 nested rows in it. The rough shape is: with…
jcollum
  • 43,623
  • 55
  • 191
  • 321
0
votes
1 answer

TFS with SSMS 2014

I've system with SSMS 2014. Windows 8.1 OS connected with remote server 2008R2Standard having SQL Server 2008R2 and TFS 2010. My system doesn't required visual studio stuff, so I don't have anything else. I just installed with SSMS 2014 for my DB…
Manish Jain
  • 842
  • 1
  • 11
  • 29
0
votes
1 answer

SQL - Specific DATEADD Requirement

I have three DM_EVENT.event_code's: 'DRL' 'CMP' 'WOV' I am needing to use a date parameter to select the latest desired reporting date (in this example: '4/28/15') to pull the SUM(DM_DAILYCOST.cost_per_item) as of that date. 'CMP' and 'WOV' are…
RoedaiOnline
  • 5
  • 3
0
votes
0 answers

Query Timeout in ADO.net but it works in SQL Server Mgmt Studio

This is my configuration: Windows 7 Pro 64b SP1 Microsoft SQL Server 2014 - Microsoft SQL Server Management Studio 12.0.2000.8 Microsoft .NET Framewrok 4.5.1 SDK Microsoft Visual Studio 2013 (v12) I’m experiencing a problem when I try to run…
Mirco Castellani
  • 13
  • 3
0
votes
1 answer

Cannot connect to local SQL SSMS2014

I just installed SQL Server Management Studio 2014 and I am trying to log in to my server but it is not allowing me to log in. I have attached a screenshot but basically when I enter my server name is say "Cannot connect to MYSQLSERVER" I have…
Rguarascia
  • 193
  • 3
  • 20
0
votes
2 answers

Integrating Entity Framework 6.0 with Postgres 9.3

I have a local database developed in Postgres 9.3. The Postgres server name on my computer is just "localhost". I would like to use the Entity Framework 6 Designer that is built into Visual Studio 13 to automatically generate a data model of EF…
harpagornis
  • 103
  • 3
  • 17
-1
votes
1 answer

Filter a column based on value and get count

I have a column Startime datetime2(7) and the data format is 2019-05-15 22:33:55.0000000. I'm trying to filter column and get the count by hour SELECT * FROM vehicles WHERE vendor = 'ford' AND starttime BETWEEN '05/01/2019 00:00:00' AND…
Mr_gemini
  • 43
  • 1
  • 6
-1
votes
3 answers

Getting results for Top 10 products

I'd like to return results (units, cash, price, cost, etc) for a specific group of products (the top 10 products in a specific Department). The code I've written below lists the top 10 at the end of the WHERE clause but doesn't return results - it…
Mr 2017
  • 103
  • 2
  • 6
  • 15
-1
votes
1 answer

The file name is not valid - even with just one character! the letter "a"!

I'm using SSMS 2014 in an Oracle Virtual Box and I'm trying to save a file to a shared drive that I've previously saved files to. However, I'm getting an error that says "F:\a.sql The file name is not valid" The file name that I tried to save…
Mr 2017
  • 103
  • 2
  • 6
  • 15
-1
votes
1 answer

Grouping by quarter

How do you group weekly data into quarterly data in SQL? I'd like the code below to return the columns selected in the statement but sum up sales by quarter rather than return weekly data. My code: select pz.PriceZoneID, pz.Name, …
Mr 2017
  • 103
  • 2
  • 6
  • 15
1 2 3
…
13
14