Questions tagged [ssms]
SQL Server Management Studio, a graphical front-end tool shipped with SQL Server for managing and querying databases. It also supports managing other bundled systems such as SSAS.
1,291 questions
2 votes
1 answer
222 views
BULK INSERT from a CSV file not working
I am a newcomer to Stack Exchange who is a beginner self-studying SQL. I need help troubleshooting an issue related to bulk inserting data from CSV files into SQL tables. Environment: SQL Express SQL ...
- 21
-1 votes
1 answer
53 views
Couldn't import excel file in my SQL(SSMS) but the "IMPORT" and "EXPORT" are greyed or faint that it can't be clicked on
I have created my Database,then highlighted the database and right-clicked ,then TASK and to IMPORT but both IMPORT and EXPORT are faint.
- 1
4 votes
1 answer
695 views
What is Microsoft SQL Server doing when I manually reduce the file size in Database Properties > Files?
In Microsoft SQL Server I can go into Database Properties > Files and change the Size of a file to a lower number. If there's space available, it will actually reduce the file's size, and never ...
- 59
-2 votes
2 answers
104 views
Maintenance Plan Wizard on 2025 (R1)
I’m experiencing issues with Microsoft SQL Server 2025 (RC1) because there are no maintenance plans. It’s not a problem — I can create a job instead. However, I’d like to know how to install or enable ...
0 votes
0 answers
55 views
Setting for saving with headers in SSMS
I've recently updated to SSMS 21.4.12, where I was previously running the 2019 version. In the old version, I was able by default to save with headers when exporting to file with right click save as, ...
- 1
1 vote
1 answer
118 views
Need help determining ideal batch size for querying a large table
I have a table with maybe around 180-200k rows (~40 columns) that I'm trying to query. The premise is that there's a list of strings to compare an FK column against, totaling around 170k passed as an ...
- 11
7 votes
3 answers
2k views
Why didn't the transaction fail?
I used SSMS to add a composite primary key to a table with 64 million rows. Because the table was so large, I used the change script generated by SSMS. One of the PK fields (REVENUE_CODE) originally ...
- 135
4 votes
1 answer
178 views
Grid Result Scroll Bars in SSMS 21
Microsoft giveth and Microsoft taketh away. In this case they appear to have removed a feature in SSMS 21. In previous versions, as well as in the current text editor, as well as practically every ...
- 3,207
1 vote
0 answers
64 views
How do I fix mixed line endings in SSMS?
I have no idea how this happens, but in SSMS (version 21) occasionally the line endings go wrong. I’m teaching online to users with Windows and SSMS and suddenly they get errors with the GO keyword. ...
- 3,207
2 votes
2 answers
620 views
SSMS21 on windows 2022 server opens a new instance every time I double click a sql file
When I installed SSMS21 on windows 2022 server I noticed the extremely disruptive new feature where it will not use the open and logged in instance of SSMS when I double click a .sql file. Instead, ...
- 31
5 votes
3 answers
2k views
Extensions in SSMS 21
I have just installed SSMS in Windows 11. There is an extension I have used in previous version to run single statements. It’s called SSMSExecutor (https://github.com/devvcat/ssms-executor). Since the ...
- 3,207
1 vote
0 answers
143 views
Can SSMS 21 execute a single statement without highlighting?
Somehow I missed out on the upgrade to SSMS 21. There’s some naive part of me that hopes that they’ve finally added the ability to run the current statement without first highlighting it. I can’t find ...
- 3,207
4 votes
2 answers
1k views
SSMS 21.0.1 - can copilot integration be stopped?
SSMS 21 is out of preview and now generally available - now integrated with Visual Studio installer as per the picture below: Do we need to consider the implications for copilot integration in SSMS ...
- 17.3k
0 votes
2 answers
159 views
How do I temporarily disable SQL Complete for SQL Server Management Studio?
I am using SQL Server Management Studio 20.2 (SSMS) with the SQL Complete v7.0.362 add-in installed. While I enjoy having it installed, I sometimes want to disable it temporarily to troubleshoot ...
- 111
0 votes
1 answer
71 views
Database User properties window error. Azure SQL Managed Instance, AAD Users
I manage a dw that's hosted by Azure, and all Logins on the server (except for a couple service accounts) are Azure Active Directory logins tied to my company's tenant. When granting db_reader access ...
