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

Incorrect error message in SQL Server script

I was used to use alter script base on table dbVersion and each change in database was in if statement. for example: DECLARE @DbVersion BIGINT, @now DATETIME = GETDATE() IF NOT EXISTS (SELECT 1 FROM sysobjects WHERE TYPE = 'U' and NAME =…
Davecz
  • 1,199
  • 3
  • 19
  • 43
2
votes
0 answers

Add Item to Object Explorer Context Menu in SSMS

I am writing a VSPackage Extention for SQL Server Management Studio (SSMS) 2016. I am currently facing the challenge to add an item or a submenu in the "right-click" context menu when clicking on a SQL Server Instance. I want to add a submenu of…
tuxmania
  • 906
  • 2
  • 9
  • 28
2
votes
2 answers

SQL Query With Nearest Date for BackFilling

I have two tables. Comments - CommentId - Comment - CreateDate - SomeCompositeKey Exceptions - ExceptionId - Color - CreateDate - SomeCompositeKey - ...and so on... My Comments table is getting a new Color column added to it…
mche
  • 616
  • 10
  • 16
2
votes
1 answer

Partitioning and Ordering in Multiple Union Statements

Good morning, I am working on combining many metrics for our dashboarding team into a single executable stored procedure they could copy into Excel and then let pivot tables do some magic. That being said, for the sake of this question I will only…
ct253704
  • 21
  • 3
2
votes
3 answers

Unable to export my .xlsx to my Sql server 2008 database

I have an excel sheet .xlsx extension with around 500,000 row and 16 columns. and i want to import it inside our sql server database which runs under windows server 2008 R2. so i tried the following steps inside my SQL Server Management studio 2008…
John John
  • 1
  • 72
  • 238
  • 501
2
votes
1 answer

How to disable Autocommit Mode in SSMS?

How can I disable the Autocommit Mode in SSMS? I don't want it to save it all to make the transaction more sure. If the transaction is successful, it will complete and if it's not, it will fail for sure. I think by default it's on in SSMS...
MasterKas
  • 87
  • 1
  • 7
2
votes
1 answer

In SQL Server Management Studio, how do I set up the keyboard shortcuts so that ctrl+w closes an XML window?

In SQL Server Management Studio, how do I set up the keyboard shortcuts so that ctrl+w closes an XML window? I know how to do this for a regular query window. Here's how. But some of my tables have XML columns, and when I click on an XML value, it…
user2023861
  • 8,030
  • 9
  • 57
  • 86
2
votes
1 answer

Unable to connect to Azure through SSMS (Microsoft SQL Server, Error: 53)

Getting below error,everytime i try to connect to azure server through SSMS. Listed the IP client address in server firewall but still not working. Microsoft SQL Server, Error: 53 I am using azure student license under Microsoft Imagine…
Dikna R Yahdi
  • 33
  • 6
2
votes
0 answers

Error: 17828, Severity: 20, State: 3. in Microsoft SQL Server 2008 R2(Standard Edition)

I can able to login the sql server through SSMS.But while connecting the server from other applications it throwing the below error. Error: 17828, Severity: 20, State: 3. The prelogin packet used to open the connection is structurally invalid; the…
SujithTee
  • 125
  • 2
  • 3
  • 12
2
votes
2 answers

sql server management studio code completion

I've noticed that whenever I add tables / stored procs / functions / whatever to a sql server database, that it takes a while for the code completion to pick up that they are now part of the database. This is really annoying since the code…
chuck taylor
  • 2,476
  • 5
  • 29
  • 46
2
votes
5 answers

Creating sql server db backup

I'm trying to create a database backup and I'm pretty new to this. I've created the .bak file already. Do I need to backup the mdf and ldf files too?
Luciana Rodrigues
  • 29
  • 5
2
votes
1 answer

Grantor does not have GRANT permission

I have a gitlab user and a role assigned to it, now the gitlab user needs extra grant permissions. I am executing the following sentence. [ssms 2012] GRANT VIEW SERVER STATE to xxx; ERROR: Grantor does not have GRANT permission What is the…
user6826691
  • 1,813
  • 9
  • 37
  • 74
2
votes
1 answer

Optimization TSQL with R

We're using TSQL with R on Microsoft SQL Server 2016 in a project. The problem is the execution time, the usage of R or the connection take a random time between 200ms and 600ms. I think it's a configuration problem but I've never used this…
Alexis
  • 5,681
  • 1
  • 27
  • 44
2
votes
1 answer

Concat variable #s of strings

I have a table that looks like this: Names uniqueid crosby,stills,nash 1 crosby,stills,nash,young 2 crosby 3 stills 4 nash 5 young …
T.Hannah
  • 111
  • 9
2
votes
1 answer

How to export huge data from sql server into excel file

I want to export huge data(about 5 millions rows with 2 columns) from sql server management studio into excel file, but the maximum size of excel file is around 1400000 rows i tried import and export wizard but it does not work perfectly it returns…
askm
  • 195
  • 1
  • 7
  • 19
1 2 3
…
99 100