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

SQL Server 2008 Management Studio - Running Parameterized Query

I'd like to be able to run an already parameterized query from within the SSMS: select name from aTable where id = @id I know that other IDEs (e.g. TOAD) allow for parameter binding - is this available in SSMS 2008? Thanks!
Jarrod Dixon
  • 15,727
  • 9
  • 60
  • 72
2
votes
1 answer

SQL getting leaf nodes of XML

I am trying to parse xml data for any leaf nodes It is structured like this: .... ... …
hashbyte
  • 121
  • 1
  • 4
  • 10
2
votes
1 answer

How to handle job failure in SQL Server Management Studio?

I have created a scheduled job in SQL Server Management Studio which executes a stored procedure at a specific time. However, some of the time it fails to execute the procedure due to deadlock, as seen in Job history. Now I want to insert a value…
Sameep Baxi
  • 111
  • 1
  • 4
  • 17
2
votes
2 answers

PIVOT or UNPIVOT: Will either work?

I have looked around for examples that are specifically like what I have but I just can't find anything. From what I've seen I'm not sure it's possible but I figured I'd ask here first. 1. Original Table I have a table that looks like this:…
B.Scar
  • 47
  • 5
2
votes
2 answers

Import Excel file located in SharePoint Server into SSIS

In an SSIS Data Flow Task I seek to import data using an Excel Source Task connected to an xlsx file located in a SharePoint server, preferably without downloading additional software. In the Excel Connection Manager I use the following Excel file…
Michelle Turner
  • 314
  • 5
  • 22
2
votes
2 answers

Export Database as Scripts; Sequences not set correctly

I want to take a Database from a SQLServer 2016 and set it up on a 2014 server on a clients' site. In SSMS I select Tasks => Generate scripts... and get a SQL file containing all CREATE TABLE statements and the like. I'm under the impression that…
Bernhard Döbler
  • 1,960
  • 2
  • 25
  • 39
2
votes
2 answers

In SSMS, what is the number shown to the right of the login name?

I looked into the properties of the connection, and did not see anything matching the number.
Sabuncu
  • 5,095
  • 5
  • 55
  • 89
2
votes
1 answer

Change destination folder in SQL Server Database backup plan

I've already created a backup plan in SQL Server 2012 using their Maintenance Plan Wizard. This plans runs every midnight and stores the backups at the default location C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup . But,…
nam
  • 21,967
  • 37
  • 158
  • 332
2
votes
1 answer

Unable to connect SQLEXPRESS with Laravel 5.6

I'm trying to connect Laravel 5.6 to my SQLEXPRESS. When I try to migrate tables from Laravel to SQL, I am getting this error: SQLSTATE[08001]: [Microsoft][ODBC Driver 13 for SQL Server]TCP Provider: No connection could be made because the target…
Greg Ostry
  • 1,161
  • 5
  • 27
  • 52
2
votes
1 answer

Turn off auto committing in SQL Server Management Studio (SSMS)

I’m looking for an option to explicitly commit/rollback every query executed in SSMS without the need to start the transaction explicitly. By default SSMS auto commits leaving no option to rollback.
kalitsov
  • 1,319
  • 3
  • 20
  • 33
2
votes
4 answers

SSMS error 0x80070643

I am trying to install SSMS 2017 and i got the following error. [307C:1F00][2018-05-19T18:52:38]i000: MainViewModel.OnPackageAction: Install Completed for package Microsoft System CLR Types for SQL Server 2017 [307C:1F00][2018-05-19T18:52:38]i319:…
cgomezfandino
  • 55
  • 1
  • 7
2
votes
1 answer

Using db names in dynamic SQL select statement

Apologies all, I am relatively new to dynamic SQL and I could do with some help please? I am struggling with making my query loop between databases. I can get the query to run and return results but it's not moving between databases -- DECLARE…
jonny mathias
  • 21
  • 1
2
votes
2 answers

Update a column when price column of other table is modified. Triggers. Nested tables. SQL Server

In my database I have about 10 tables connected in one central table (Mobile). This table (Mobile) has a column called price which is the sum of the prices of all other nested tables. I would like that when price of another table (like Battery,…
JuMoGar
  • 1,740
  • 2
  • 19
  • 46
2
votes
1 answer

Query Designer toolbar grayed out?

I am using the Query Designer in SQL Server Management Studio (on an Express 2008 database). I created a new Query, chose Design Query in Editor from the Query toolbar and was presented with a cool graphical query designer (a bit like the one in…
Paul Moss
  • 31
  • 4
2
votes
2 answers

Need help on using cursor and displaying records in sql server Error :Msg 16916, Level 16, State 1

I am trying to display the records form particular table using cursor. But its throwing this error. Msg 16916, Level 16, State 1, Procedure testload, Line 26 [Batch Start Line 1] A cursor with the name 'ShowSDFinfo' does not exist. Msg 16916,…
Arjun R
  • 77
  • 1
  • 9
1 2 3
…
99 100