| CARVIEW |
Select Language
HTTP/2 200
date: Wed, 23 Jul 2025 15:12:00 GMT
content-type: text/html; charset=utf-8
cf-ray: 963c1d0f19cf1712-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=9add1db5-e216-4050-8b8d-5338e02e7d2a; expires=Thu, 23 Jul 2026 15:12:00 GMT; domain=.stackexchange.com; path=/; secure; httponly
strict-transport-security: max-age=31536000; includeSubDomains
vary: Accept-Encoding
content-security-policy: upgrade-insecure-requests; frame-ancestors 'self' https://stackexchange.com
x-frame-options: SAMEORIGIN
x-request-guid: 98765887-9044-48ca-a8b8-c1676dd3c78e
x-worker-origin-response-time: 529000000
x-dns-prefetch-control: off
set-cookie: prov=9add1db5-e216-4050-8b8d-5338e02e7d2a; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=ZcSdNxPYOfl6eFzBCRNw70vE9OojdTa519hO.h1t0UU-1753283520-1.0.1.1-OLZ3JqB.mejTaubGJUF4caCfR.BXudcOUcqTnc..i9PWLrCBw1Qz3iu4Vi9XQlRYFHtlSKwRkY26p4cpw8Po8m08jkhsaPqA.m_SRd6KK0w; path=/; expires=Wed, 23-Jul-25 15:42:00 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=bmgisBe4EdfneCm4EoO_8wPAZJnMsyHd3A0ZblQYeHg-1753283520398-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'ssms' Questions - Database Administrators Stack Exchange
Skip to main content
Stack Exchange Network
Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about TeamsQuestions 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,284 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
1
vote
0
answers
34
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. ...
-1
votes
0
answers
17
views
SnowFlake/DataView connection to SSMS
Has anyone successfully connected SnowFlake/DataView to SSMS whether it was through VS or other means, if so, may I please know how you did it? Essentially, I am trying to get the SnowFlake data into ...
1
vote
2
answers
508
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, ...
4
votes
3
answers
891
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 ...
1
vote
0
answers
70
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 ...
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 ...
0
votes
2
answers
100
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
35
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 ...
1
vote
0
answers
36
views
Get higher severity error in a catch block [duplicate]
SQLServer2022 / SSMS20.2
I'm using a StoredProcedure to build a log of scripts execution in my DB.
It's working fine untill the execution has 2 errors.
e.g. ALTER TABLE MyTable DROP INDEX MyIndex
...
0
votes
0
answers
36
views
Install other SMO versions to avoid SSIS errors under SSMS 19?
Connecting to an older sql version's Integration Services instance will throw the Class Not Registered error and the Properties for a sql agent SSIS job step will not show (e.g. DataSources). This is ...
2
votes
2
answers
367
views
Permissions needed to start/stop SQL Agent in SSMS
I'm working on a new SQL Server instance, but the SSMS options to start/stop/restart the SQL Agent are grayed out.
I am connected from another PC. My user is in a group that has sysadmin permissions ...
1
vote
1
answer
91
views
How to disable microsoft sql server management studio recovered files screen?
I get the "Recovered Files" screen every now and then. I would like to disable it completely. I tried Tools/Options/Environment/AutoRecover and unchecked the checkbox. But it has no ...
- 1,961
0
votes
1
answer
90
views
Additional Dialog box when closing script
When ever I close a SQL Script that I am not interested in keeping or even if I am saving it, this "Query Execution Results" dialog box comes up before the regular you want save or not.
...
0
votes
1
answer
48
views
How can I take a row value make it a column and map certain values to it?
I know I could build a temp table to do this etc...but I was hoping there was another way.
Basically, I have some tables that keep track of waste / environmental stuff by state.
The query is very ...
0
votes
1
answer
127
views
% processor Time in Activity monitor is greyed out
When I connect to my SQL Server using SQL Server Management Studio (SSMS) from a remote computer, the "% Processor Time" metric in the Activity Monitor is greyed out and unavailable. However,...
- The Overflow Blog
-
-
- Featured on Meta
-
-
Related Tags
sql-server × 913
sql-server-2012 × 130
sql-server-2008-r2 × 95
sql-server-2016 × 88
t-sql × 80
sql-server-2014 × 77
sql-server-2008 × 71
restore × 45
backup × 35
ssis × 33
azure-sql-database × 32
sql-server-2017 × 32
sql-server-2019 × 32
permissions × 30
intellisense × 24
execution-plan × 22
scripting × 21
sql-server-agent × 21
connectivity × 20
stored-procedures × 19
sqlcmd × 18
installation × 17
import × 15
performance × 15
sql-server-2005 × 15
more related tags
Hot Network Questions
- I wonder whether there exists a book of "Formal power series" and "Formal infinite products"?
- Must hospitals care for unidentifiable individuals indefinitely?
- What does this "lightbulb-ish" symbol mean in figure 1 of the Diffie Hellmann paper?
- Is there a smooth function approximating the minimum of a constant and a variable?
- bootstrapping for variance estimation takes too long
- What fiction genres do literary agents recognize?
- Can you identify this shell case from Flanders?
- How would a DiVicenzo machine prepare the maximally mixed state with a small number of ancilla qubits?
- Is there a way to retrieve my inventory from the void in Minecraft Java Edition?
- Entity Framework - Is there a safety mechanism to prevent accidentally running Update-Database?
- Define command valid only for a specific environment in expl3
- Why is my gooseberry jam so stiff?
- Axioms of quantum mechanics - intuitive explanation
- Australian TV show about two dimensions separated by a deteriorating purple energy wall
- Ubuntu gives the message "You are in emergency mode."
- Is buying random stocks and then selling off the ones that go down a good way to reduce capital gains tax?
- Did Webster's Dictionary define Fascism by its relationship to corporations until 1987?
- Which PowerShell commands are automatically scrubbed from Get-History?
- Praesul meorum tattoo
- Sum of ranks of blocks
- In QGIS installed via OSGeo4W on Windows 11, what is the path to the command history file for the Python console?
- Console-based Casino Game in C++
- Why were two 2x6 boards installed on top of a window rough sill?
- Is a chemistry-first technological paradigm as plausible as one focused on physics or biology?