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

SSMS 2014 Backup and Restore Issue

I have a Windows server 2012 instance running SSMS 2014. I connect to that computer from a Windows 7 machine also running SSMS 2014. When I perform a backup and copy the .bak file from the server to my local machine and try to run a restore,…
ercmcd
  • 143
  • 1
  • 1
  • 9
0
votes
0 answers

SQL Server Management Studio 2014 Memory Usage unusually high

SQL Server Management Studio 2014 and is drawing over 1 GB memory every time it is launched. Often the program becomes unresponsive. Even when no queries are running. I was using it yesterday with no problems. I don't believe that I made any…
bjurstrs
  • 949
  • 2
  • 7
  • 17
0
votes
1 answer

Weave variables into table names in TSQL

I'm attempting to learn to use dynamic SQL to automate what would otherwise require a lot of typing. However, this would include putting variables directly into table names (not as the whole table name). When running the below query directly in…
Andy
  • 3,132
  • 4
  • 36
  • 68
0
votes
0 answers

SSMS 2014 does not display windows correctly

I just upgraded 2008 sql server to 2014 and now almost all of my windows look like this: I didn't have any problems like that in 2008 R2, but not it is really annoying. Does anyone know how to fix it?
Nicky
  • 97
  • 8
0
votes
0 answers

SSMS 2014 Table Designer - Data Type AutoComplete Not Working Properly

I just noticed this odd bug and was wondering if anyone else has seen it and knows of a solution. When using the table designer, if you tab into the data type field and start typing, the field will not clear entirely to allow you to enter the type…
WonderGrub
  • 396
  • 1
  • 10
0
votes
1 answer

How to avoid ALTER TABLE XXX ADD YYY statements in files generated by SSMS?

I need to generate an SQL script from my MS SQL Server database. In that end, I used the "Generate scripts..." tool provided by SQL Server Management, which worked. However for one single table, some of the fields are not included in the CREATE…
Nicolas Seiller
  • 564
  • 1
  • 10
  • 20
0
votes
2 answers

Multiple words in Where field LIKE

I have a list of values (words) and I want to check if a column in my table contains a value (any value) from the list. My list can be very long so I want to create it using a for loop, for example: words = ( 'one', 'two', 'three'…
user5435739
  • 73
  • 2
  • 2
  • 6
0
votes
2 answers

SQL error with order by clause

I am getting the error The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified for below code, SELECT MIDDLE.MODEL AS Model, …
Nilanjan Joshi
  • 31
  • 1
  • 4
0
votes
2 answers

how do I do in SSMS to have a script loaded each time I press "New Query"?

When I press New Query on SQL Server Management Studio (SSMS), according to the following picture: I would like the following script in a new tab. would this be possible? USE AdventureWorks2012; GO -- SET XACT_ABORT ON will render the transaction…
Marcello Miorelli
  • 3,368
  • 4
  • 44
  • 67
0
votes
1 answer

SQL Server Management Studio: select permission for a view 'access to path is denied'

I have a problem with permissions on a database in SQL Server 2014. Group G has select permission on schema S1, which contains a lot of views. When I connect as a user I can see all the views but when selecting 'top 1000 rows' I get the error…
Aswin
  • 1
  • 2
0
votes
0 answers

An Error Occurred Attempting To Delete Row 6 - SSMS 2014

No Rows were deleted. A problem occurred attempting to delete row 6. Error Source: Microsoft.sqlServer.Management.Data.Tools. Error Message: The updated rows has changed or been deleted since data was last retrieved. Correct the errors and…
Sixthsense
  • 1,927
  • 2
  • 16
  • 38
0
votes
1 answer

SQL Server 2014 Computed Column Specification Calculated Field Formula Error

Using the below column names in the formula field of computed column specification category (using Management Studio). [[App_1]+[App_2]+[App_3]+[App_4]] I'm getting this error: 'MyDatabase' table Error validating the formula for column…
Sixthsense
  • 1,927
  • 2
  • 16
  • 38
0
votes
1 answer

How do I create a login user that can only view data?

I'm working with MSSQL Server Management Studio 2014. I am trying to create a login that can view a database's tables, functions and users. Also generate scripts for the database, but not run the scripts. The login shouldn't be able to delete,…
dikokob
  • 85
  • 3
  • 12
0
votes
0 answers

SSMS 2014 Select Query taking too long and not giving any result or Error

I am trying to execute select statement in SSMS 2014. But it is taking too long and not providing any results. I waited for 30 minutes but still I did not receive any result. Can someone please suggest me the solution for this. Thank You
Anirudha.I
  • 43
  • 5
0
votes
1 answer

SSMS Addin - GetHierarchy Method Is NULL

I'm writing an addin for SSMS 2014. I want to get hierarchy for search an item in ObjectExplorer. But GetHierarchy method comes null. Does anyone have any ideas? ObjectExplorerService objExplorerService =…
Nusret Parlak
  • 83
  • 8
1 2 3
…
13 14