Stack Overflow
Stack Overflow

Questions tagged [ssms]

Microsoft SQL Server Management Studio is a graphical tool for configuring, managing, and administering all components within Microsoft SQL Server.

SQL Server Management Studio is a tool included with Microsoft SQL Server 2005 and later versions 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

7484 questions
2
votes
1 answer

Issues importing data-tier application to Azure SQL server

I am trying to import a .bacpac of a local sql database to my Azure SQL Server using SSMS, but it fails with the message Error SQL72014: .Net SqlClient Data Provider: Msg 15063, Level 16, State 1, Line 1 The login already has an account under a…
Alistair67
  • 59
  • 11
2
votes
1 answer

SQL Server Profiler, Management Studio and Operations Studio hang after updating XML Data option

I've been using SSMS, SQL Server Profiler and SQL Operations Studio for a while now without issue. However, when some query text (TextData column) was getting truncated in the profiler, I decide to increase the SSMS "XML Data" size to "5 MB". Now…
alan
  • 6,705
  • 9
  • 40
  • 70
2
votes
1 answer

How to stop a SQL job showing 'In Progress' status?

I am using SQL Server 2014 and I have a job (called ITB) which has been scheduled to run at 4.00am on a daily basis. The SQL job has 11 steps in it. At 09.00 am this morning, I noticed that the job was showing 'In Progress' in the job history. It…
user3115933
  • 4,303
  • 15
  • 54
  • 94
2
votes
1 answer

SQL Incorrect Syntax Near 'GO'

I am getting the error in my sproc and I cannot figure out why. I have looked at other, almost identical questions like this Here and the answers aren't doing the trick for me. the syntax error is at the 'Go' right after the database creation. USE…
Robert
  • 33
  • 1
  • 4
2
votes
1 answer

Why won't default values persist in database for User Defined Table Types?

I am able to deploy a User Defined Table Type in SSMS with a default value like this: CREATE TYPE [MySchema].[Test] AS TABLE ( [TestColumn] BIT NOT NULL DEFAULT 0 ) When I pull the source after deploying the DEFAULT 0 is gone: CREATE TYPE…
NoAlias
  • 9,218
  • 2
  • 27
  • 46
2
votes
3 answers

Combining/merging multiple columns unique values in a single row

Trying to combine multiple columns and rows with a single query in SSMS. Here is a simpler version of more complex table I am working with: Here is my current query: CREATE TABLE Table1 ([C1] varchar(50), [C2] varchar(50), [C3]…
Wsi
  • 111
  • 1
  • 9
2
votes
1 answer

Unable to connect to AWS database from SSMS

I have created a Microsoft SQL server database with Amazon RDS. I have created a security group with an inbound rule which includes my IP. I modified the DB instance to include that security group. I Copy and pasted the connection endpoint and…
Bryan Moore
  • 41
  • 3
2
votes
1 answer

Parsing XML in a SQL Table

I've done some research on this topic on this site and elsewhere, and I think I'm somewhat close to a solution, but I'm still having some trouble. I have XML saved in a record that, when formatted, looks like this (This is a…
Scott Ferguson
  • 53
  • 4
2
votes
4 answers

How to Group based on Distinct value of other column

I have this input table +--------+-----------+------------+----------+ | TaskId | OwnerName | WorkerName | Category | +--------+-----------+------------+----------+ | 1 | Sara | Sara | 1 | | 1 | Sara | Maya | …
sara
  • 534
  • 1
  • 9
  • 22
2
votes
1 answer

How to choose top groups then ungroup

I have this table +-------+----------+------+ | Group | Function | Name | +-------+----------+------+ | G1 | F1 | ABC | | G1 | F1 | ABC | | G1 | F2 | ABC | | G1 | F3 | ABC | | G2 | F1 | XYZ | | G2 …
user101
  • 45
  • 2
2
votes
4 answers

Replacing SQL Server 2005 Express Management Studio with the full version

I have been running SQL Server 2005 Express Management Studio ("SSMSE"), and I now have a need to install the full version of Management Studio ("SSMS"). This is a known hassle, but I've not found a comprehensive way to carry it out. At first, I…
eksortso
  • 1,273
  • 3
  • 12
  • 21
2
votes
2 answers

How to change reference highlight color in ssms 2017?

In ssms2017 text editor, when you click some words(variable/field/tablename..etc), others same words would highlight, but this color not enough HIGHLIGHT, I want change it, but i can't find out the item in Tool>options>font and color.
ahdung
  • 350
  • 3
  • 13
2
votes
4 answers

Select distinct combination of rows based on columns

I have a table where the columns author1 and author2 have mirror data like (a,b) and (b,a). But I don't want the data to be redundant so a SQL query is needed for eliminating records that have (b,a) if (a,b) already exists. author1 …
Pumpkin Head
  • 31
  • 4
2
votes
3 answers

Upon creating a Maintenace Plan in SSMS 17.6, SSMS automatially restarts upon attempting to schedule the task to run

The architecture is Server 2016 with SQL 2016 Standard. SSMS has been set to run as administrator. SSMS 17.6 has been installed and re-installed. All Microsoft updates have been installed to the serer and the application. Creating a Maintenance…
Kurwin
  • 21
  • 2
2
votes
2 answers

SQL Server - Display only the most recent print statement in SSMS messages pane (while loop)

I have a script that usually takes several hours to run (mostly because it needs to be looped through a few hundred thousand times. Currently I have a print statement to check the progress so that each time it completes 1 iteration it prints out :…
Anonymous
  • 440
  • 3
  • 14
1 2 3
…
99 100