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

SSMS/SSRS - Get Stored Procedure Name Used by SSRS Dataset From Query

I have a query (unfinished) that gets generic SysJob/ReportServer information. The only issue I'm having is trying to retrieve the name of the stored procedure a SSRS report uses. I've tried multiple queries but in my current attempt I tried to get…
haag1
  • 352
  • 1
  • 13
2
votes
2 answers

SSMS Color tab based on connection string / Environment

SQL Server - SSMS Can we change the SSMS query tab color based on connection string? Lets say I'm connecting to different environments Prod / Dev / UAT/ Test etc... or I want to group my servers based on some other criteria
singhswat
  • 832
  • 7
  • 20
2
votes
1 answer

Utilizing Case When & Possibly "Lead" or "Lag"

I know what I want the data to display but can't seem to figure out the correct logic for it. Example below. Dataset **'ID', 'Admission Mth', 'Admission Yr', 'Category', 'Facility', 'ID_Yr_Cat', 'ID_Yr_Cat_Fac',** '123456', 'Jan', '2017',…
Cameron Cook
  • 21
  • 2
2
votes
2 answers

SQL Query works in management studio but not in C#

I have a problem doing a query with my software... I have a function which builds my query, and then execute it to fill a gridview. But it keep throwing me an exception : "The multi-part identifier "" could not be bound" with several columns. When…
Pixayl
  • 23
  • 3
2
votes
1 answer

SQL Server Arithmetic Overflow with Power() Function

I am attempting to generate a table containing values of 10^(existing_field_value / 10). I can recreate the problem with the following simplified table: Date, Time, Timer, Overall_Spectra, 6_3_Hz, 20_Hz 10/23/2018, 12:24:13, 0:19:59,…
B-Dawg
  • 31
  • 5
2
votes
1 answer

Show results from query if results exist without running the same query again

I want to have a stored procedure that will take one SerialNumber nvarchar as it's input and check several databases to see if that serial number exists and if it does exist then return the result of the query, otherwise move onto the next database…
LCIII
  • 3,102
  • 3
  • 26
  • 43
2
votes
3 answers

Msg 4104, Level 16, State 1, Line 8 The multi-part identifier "xx.ParseThis" could not be bound

The following is a very shortened version of what I'm trying to do. I know that SplitString2 works because I tested it with hard coding the string and using ID = 1. Can someone please try to explain why the last line does not work? select …
cmg
  • 23
  • 2
2
votes
1 answer

Return column based on calculated value of other columns

CREATE TABLE most_prof ( pub_id CHAR(4) NOT NULL, top_profit VARCHAR(80) NOT NULL, date_time DATETIME, PRIMARY KEY (top_profit) ) INSERT INTO most_prof (pub_id, top_profit, date_time) SELECT t.pub_id, t.title, t.pubdate FROM…
eran0801
  • 39
  • 4
2
votes
1 answer

SSMS Bulk inserts = Error + Which line is it?

I'm trying to insert a lot of data with SQL Server Management Studio. This is what I do: I open my file containing a lot of SQL inserts: data.sql I execute it (F5) I get a lot of these: (1 row(s) affected) and some of these: Msg 8152, Level 16,…
Luc PHAN
  • 316
  • 2
  • 13
2
votes
1 answer

Microsoft SQL Server Management Studio installer language conflict

I have a server with an English Version of Windows that is located in Germany, which due to "smart" behaviour of the Microsoft SQL website leads to the following problem: When I try to download the MS SQL SMS installer from the official website, it…
Kira Resari
  • 1,718
  • 4
  • 19
  • 50
2
votes
2 answers

SSMS connect to azure failure

I am connecting to azure database using ssms 17.9. i opened the firewall that allow remote connection for my office ip address. But there is a weird situation that my colleague pc ssms able to connect to azure database which mine cannot. The error…
Keith
  • 49
  • 1
  • 6
2
votes
0 answers

How do one get current connection from SQL Editor document in a SSMS 2018 extension in C#

Before, it has been possible to use something like... var scriptFactory = ServiceCache.ScriptFactory; var connectionInfo = scriptFactory.CurrentlyActiveWndConnectionInfo; var conn = connectionInfo.UIConnectionInfo; Now I am completely lost about…
Anders Eklund
  • 21
  • 1
2
votes
1 answer

Add column if it does not exist

I am running SSIS for data warehousing purposes basically it loops through all my databases and saves that data into a table. However, some tables are missing a [LastModified] column and I would like to create the column for those that do not…
theJ
  • 395
  • 5
  • 25
2
votes
1 answer

Convert Time to 0015 format Sql

I want to Convert time to 0000 format. I'm using SQL Server 2017. I've written the following query : SELECT EventName, Convert(time, EventTime) as 'Log out' From AttendanceEvents Which gives: The Format I want my Time to be is…
Dawood Zaidi
  • 278
  • 4
  • 16
2
votes
2 answers

SSMS and sp_OAMethod: is there a Data Type greater than VARCHAR(8000)?

Calling a REST service through SSMS is indeed not a great idea. BTW since Microsoft created the Stored Procedure sp_OAMethod and even Phil Factor from Red Gate show us how to use it I wanted to give it a go. I wanted to import some data from…
Francesco Mantovani
  • 10,216
  • 13
  • 73
  • 113
1 2 3
…
99 100