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

Remove special characters in SSMS (SQL Server Management Studio) query editor

In SSMS query editor, I see these arrows,dots and square whereever I hit TAB,SPACE and ENTER keys respectively. I have attached the image to be more clear in my question. Can anyone please suggest me a way to remove this and get back to the normal…
ze-corps
  • 65
  • 1
  • 9
2
votes
1 answer

Prevent clicking to set a breakpoint in SQL Server Management Studio query text editor

When editing a stored procedure, I often want to click to the left of the line to select the entire line, or multiple lines. But the breakpoint column is the natural left margin of the window pane. So I often click to enable a breakpoint by mistake,…
goodeye
  • 2,389
  • 6
  • 35
  • 68
2
votes
1 answer

SSMS Addin Not working on SSMS 2016

I wrote an Addin for MSSQL 2014. Now i upgrate my addin for MSSQL 2016 but it doesn't work. SSMS doesn't load my Addin. I copied my Addin file to "C:\ProgramData\Microsoft\MSEnvShared\Addins\". My Addin File is;
Nusret Parlak
  • 83
  • 8
2
votes
2 answers

Alternative to a many to many relationship

Let's say I have a two tables - book and author. A book can have many authors and an author can have many books, which means they are in a many to many relationship and I'll need a third table to implement that. I really want to avoid this, as I am…
Robert Ross
  • 1,151
  • 2
  • 19
  • 47
2
votes
1 answer

Custom number of successful executions in the Execution Performance report in the Integration Services Catalog

I want to ask if it is possible to change parameter "number of successful executions" inside the Execution Performance report in the Integration Services Catalog? See picture: Let say I would like to see 1000 instead of just 10 executions. Thanks…
Lkor
  • 434
  • 3
  • 12
2
votes
0 answers

SSMS 2016 crashes in Edit Top X Rows for Windows 10

I'm having a problem where SSMS will crash while trying to scroll through the results of the "Edit Top X Rows". I have tried reducing the number of rows returned, installing older versions of SSMS, and making sure I am on the latest versions. I…
KevinSwiecicki
  • 131
  • 1
  • 4
2
votes
0 answers

SQL Server add user to database MDF

Before you ask, I'm not trying to hack anywhere, just debugging a faulty application for issues that support doesn't cover. I have a MDF file from SQL Server 2012 where a limited-rights user was created. I have installed another copy of SQL Server…
tsmr
  • 198
  • 11
2
votes
1 answer

Select returns no rows - queries in trace file

I imported a trace file using SELECT * INTO trace_table FROM ::fn_trace_gettable('c:\my_trace.trc', default) While analyzing my imported trace file i noticed that certain select statements take a significant amount of time (duration) and cpu but at…
surfmuggle
  • 5,527
  • 7
  • 48
  • 77
2
votes
2 answers

SSMS object explorer sorting order?

I created the following schemas and hope their objects be shown at the bottom of object tree. However, they are on the top instead. Is there any special characters that be shown in the bottom in SSMS explorer tree? create schema [~temp] create…
ca9163d9
  • 27,283
  • 64
  • 210
  • 413
2
votes
4 answers

Login failed to local SQL Server

I've seen a lot of questions on here about being unable to find a local instance of SQL Server. I can find it; I just can't figure out what it wants for authentication. Windows authentication doesn't work and I can't leave the user name and…
ccwscott
  • 51
  • 1
  • 8
2
votes
2 answers

Creating new view in SSMS not working

I apologize for this newbie question, but after years of working with MS Access I'm using my Azure subscription to setup my first Azure SQL Server. The whole deployment process in Azure was very simple, and I'm now able to open my database in SQL…
abjarna
  • 21
  • 2
2
votes
1 answer

Merge Statement in SQL not working for delete in Target

I want to use the merge statement to update the table PersonalDetails with the STG2PersonalDetails table. I want it to update Target if Source is present matching on PersonalID. I want it to insert into Target if Source is not present in target…
Lauren Buxton
  • 95
  • 8
2
votes
2 answers

How to remove shortcut command Ctrl+E in Management Studio

I'm really frustrated by this shortcut because I commonly use both Emacs and Management Studio for different projects. However accidentally pressing CTRL + E in MS and expecting cursor to move to the end of the line, which it does in my Emacs…
Tinkerer
  • 51
  • 3
2
votes
1 answer

Can you generate xml feeds in ssms with images/pictures

I am designing my database to hold records of user profiles. These user profiles have the standard: title, name, biography and each have a picture which I need save in the table also Title Name Biography Image I need to generate an XML output for…
Lauren Buxton
  • 95
  • 8
2
votes
1 answer

How to script non-default collation and skip explicit scripting for default collation?

In SSMS 2008 R2, I created a table: aTest(Albnian varchar(10), Dflt varchar(10)) In SSMS table designer, both columns have the collation: "" (under "Column Properties" → "Table Designer") I changed the collation of the column…
Gennady Vanin Геннадий Ванин
  • 10,136
  • 11
  • 75
  • 106
1 2 3
…
99
100