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

SSIS script task fail version 15.0 script?

I have a 2012 SSIS project that runs on SQL Server 2016. I have SSDT 2015 on both my dev machine and server. Everything works fine except for script tasks - I made a change to an existing script task and rebuilt and redeployed the project and I…
JD84212
  • 65
  • 1
  • 5
2
votes
1 answer

Modifying cells in SQL Server Management Studio 2005 without a mouse

I'm always making manual changes to a lot of data as part of my job. One thing I've noticed is that I can use the arrow keys to browse around to different cells when viewing the data. But when I go to a new cell, the entire text in it is…
Joe Phillips
  • 49,743
  • 32
  • 103
  • 159
2
votes
1 answer

Unable to view json file in SQL grid

I am trying to generate json data through sql queries. I used "For Json Auto" to generate json. One of the table contains html data with html tags. At the time of retrieving it in json it gives me error like : TITLE: Microsoft SQL Server Management…
CEAD
  • 21
  • 4
2
votes
1 answer

Why cannot I delete (edit) a row with xml value in SSMS?

In SSMS 2008 R2 I execute: create table aaa(col1 xml); go insert into aaa (col1) values('ddd') go 2 Then, open table in SSMS (right-clicking the table in Object Explorer) with "Edit top 200 rows" option, select a row, press delete…
Gennady Vanin Геннадий Ванин
  • 10,136
  • 11
  • 75
  • 106
2
votes
4 answers

SQL Server Management Studio 2016: The application cannot start

I installed SQL Server Management Studio 2016. When I tried to open it gives this error. I tried uninstall and again install. Also I uninstall all Visual Studio and SQL Server and reinstall all of them but problem still continue. How can I solve…
Taha
  • 347
  • 1
  • 4
  • 9
2
votes
1 answer

SQL - find most recent promotion date

Say I have a table "EmployeePromotions" with data similar to: Job_Title Job_Description Name Effective_Date DM1 Manager John Doe 12/01/2016 AM1 Manager John Doe …
Jorjo Peralta
  • 75
  • 4
2
votes
0 answers

Drag & Drop of text in visual studio causes exception

in any project, dragging and dropping any text cause the following exception: "An exception has been encountered, This may be caused by an extension You can get more information etc. " the activity log contains this: …
YannickM
  • 23
  • 4
2
votes
1 answer

List of dates from while loop

I have the following while loop: DECLARE @Date Date DECLARE @Trucks INT DECLARE @MaxTrucks INT SET @Date = DATEADD(mm, -1,DATEADD(mm, DATEDIFF(mm,0,GETDATE()),0)) SET @Trucks = 0 SET @MaxTrucks = 0 WHILE @Date <…
user7947628
2
votes
1 answer

select the lastest invoiced date from each customer invoice, with multiple invoices from same customer

I just need it to pull the top 'last invoiced date' from the table not everything. any idea how to do that? Or could anyone point me in the right direction. I am a novice to sql queries. I'm using MS sql sever 2016. Vendor_Number Vendor_Name …
Jenesis
  • 109
  • 1
  • 1
  • 9
2
votes
1 answer

Cannot create or find Schema in SQL Server 2016 Express

My program creates databases and tables at runtime. My understanding of Schema is it is a conceptual folder for multiple databases and databases tables. So I wrote some meaningless code just to test out what schema would do to my code. My program…
KMC
  • 19,548
  • 58
  • 164
  • 253
2
votes
2 answers

Write T-SQL Result Lines to Individual Files

I am working on a proprietary data warehousing product that has a metadata table containing the SQL queries used to populate it. I need to extract each of these queries from the metadata table and save it to its own .sql file, named according to the…
MCP
  • 23
  • 4
2
votes
2 answers

The SQL script returns different values when run from SSMS and BSQLDB

I am trying to run the same script against SQL 2012 SERVER using SSMS (on Windows OS) and BSQLDB (on RHL Linux). The output for both these clients is different. The script involves concatenation with null values. here is the simplified version of…
Kritul Rathod
  • 75
  • 1
  • 11
2
votes
1 answer

How do i set password to zip file in SSIS?

I have compressed file by 7-zip using Execute Process Task in SSIS. Now i have to set password to zip file How can i achieve that ?
vinoth kumar
  • 216
  • 4
  • 15
2
votes
0 answers

Installing R packages in Microsoft SQL Server Management Studio

I'm currently trying to run a R-script in SSMS 2016. I log on to a server (via remote desktop) to run SSMS, and in SSMS I connect to yet another SQL server. I believe this is what causes my error: When I try to install a R package such as dplyr, I…
Jesper
  • 21
  • 3
2
votes
0 answers

Add in - SSMS Tool Error Pack error in SQL Server 2008

I am getting an error Add in-SSMS Tool Error Pack error SQL Server 2008 whenever I open SQL Server Management Studio. I already tried to uninstall and reinstall SSMS Tool Pack, but the error is not resolved. Here's a screen shot of the…
Shishant
  • 69
  • 6
1 2 3
…
99 100