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

T-SQL code snippet with time of insertion

I have a question concerning the code snippet functionality in MS SQL Server Management Studio. I want to create a snippet that will contain the current date and time in some predefined place of code at the moment when the snippet is added. Not when…
Konrad
  • 1,014
  • 1
  • 13
  • 24
2
votes
2 answers

“Prevent saving changes that require the table to be re-created” Microsoft SQL Server

I was modifying a column in SQL Server 2016 Management Studio (SSMS) and got the error: The changes you have made require the following tables to be dropped and re-created I'm testing and so I don't have any problem with dropping and…
NBajanca
  • 3,544
  • 3
  • 26
  • 53
2
votes
0 answers

Intellisense is not working for some databases

When I work with different servers, some of the databases queries does not show IntelliSense. why is that?
Myurathan Kajendran
  • 647
  • 3
  • 8
  • 15
2
votes
4 answers

SQL server 2008 management studio syntax error

I'm very very new to programming. I'm having the hardest time with a seemingly simple insert statement that I'm using a query to run. The following is exactly what I am putting in: INSERT INTO [EMPLOYEE TABLE] (list of column names surrounded by…
winkyloCC
  • 31
  • 1
  • 2
  • 7
2
votes
2 answers

SQL Server Search Database Objects "on the fly" with Native SSMS Functionality / SSMS Boost

TLDR: What I am ultimately looking for is to be able to highlight some text in the SQL Query Editor (which would be a partial object name), then press a keyboard shortcut (for example CTRL+5) which would search the current database for objects based…
JoeFletch
  • 3,820
  • 1
  • 27
  • 36
2
votes
2 answers

Microsoft SQL Server 2016 - SSMS, cannot expand tables for a database

There are many databases on my server, recently of them one (which I am the dbo on) has become inaccessible through SSMS. When I expand the tables node in 'object explorer' for this database I get the following error: Subquery returned more than 1…
j3r0
  • 31
  • 2
  • 7
2
votes
1 answer

Is there a way to start SSMS and autoconnect to different servers?

Is there a way to start SSMS 2016 and autoconnect to different servers? So that I don't have to do this manually every time I start SSMS. An SSMS add-on?
Tony_Henrich
  • 42,411
  • 75
  • 239
  • 374
2
votes
2 answers

How to view SQL Server query logs like MySQL general query logs

Can we view logs of all queries in SQL Server like MySQL general query logs? How can this be achieved?
Atul Mishra
  • 298
  • 2
  • 11
2
votes
1 answer

Single Record View, like PL/SQL Developer

Is there any way to show result pane in SQL Server like PL/SQL Developer, option Single Record View? PL/SQL Developer print example:
Luis Antonio Pestana
  • 993
  • 2
  • 9
  • 24
2
votes
4 answers

SSMS: How to sort objects by date?

i created a stored procedure recently, and i would like to sort the list of stored procedures by date. 12 years ago this was easy: What is the preferred way to accomplish this in SQL Server Management Studio? Bonus: How to sort by owner?
Ian Boyd
  • 246,734
  • 253
  • 869
  • 1,219
2
votes
3 answers

How can I make the Tab Drop Down In Sql Server Management Studio display more of the File Names

Am I the only person annoyed by this? I don't even know what proc I'm clicking on if the file names have the same prefix, or are longer than the context window width.
Ryu
  • 8,641
  • 10
  • 65
  • 98
2
votes
2 answers

MS SQL define default value for each column name via query loop

Hey all I am hoping someone has a script that helps with bulk Say I have a table like so: CREATE TABLE [dbo].[Table_3]( [value1] [varchar](50) NOT NULL, [value2] [varchar](50) NOT NULL, [value3] [varchar](50) NOT NULL, [value4]…
StealthRT
  • 10,108
  • 40
  • 183
  • 342
2
votes
5 answers

An exception occurred while executing a transact-sql statement or batch

I keep getting the error message: an exception occurred while executing a transact-sql statement or batch when trying to do anything in SQL Server Management Studio 2016. This occurs when I try to create or edit a login, when I try to create a…
krishna
  • 163
  • 1
  • 2
  • 7
2
votes
2 answers

SQL Server generated bug data script how not to set the IDENTITY in the insert statements?

I'm using SQL Server Management Studio to generate a SQL script (big one) to update an Azure SQL database. The problem is that the script is generated with IDENTITY on and the insert statements are exported with the ID column which as result cause…
user63898
  • 29,839
  • 85
  • 272
  • 514
2
votes
2 answers

SQL Server Management Studio reset all styles

So I messed up my sql server management studio when I was trying to make it have a "dark theme" as I use it a lot and it was starting to wear on my eyes. While doing this, I specified for the output window to have a black background with white text.…
Ryan
  • 970
  • 15
  • 36
1 2 3
…
99
100