Questions tagged [ssms]
SQL Server Management Studio is an IDE for administering Microsoft SQL Server.
117
questions
0
votes
2
answers
38
views
Why does SSMS generate many tilde files when saving a SQL file?
I'm using SQL Server Management Studio (SSMS) 20.1 to edit a file containing SQL commands. The file itself, sqlCommands.sql, is being provided via a WebDAV server that we've written. If we make an ...
0
votes
2
answers
1k
views
after upgrade to win11 runas.exe no longer passes windows credentials to SSMS
On Friday I had to change my domain password and my employer upgraded my machine to Win11 over the weekend. There also seems to have been an upgrade to our security software. Not sure which parts of ...
-1
votes
1
answer
785
views
How to uninstall SSMS 19.1 completely with absolutely all settings?
SSMS 19.1.56.0 English-US
Windows 10.0.19044
I want to remove it absolutely completely with all settings. After a re-install, it should behave like installing on a fresh computer.
Currently, when I ...
0
votes
1
answer
212
views
Occasional empty folders in Object Explorer tree in Microsoft SQL Server Management Studio
I'm using Microsoft SQL Server 2022 Express and Microsoft SQL Server Management Studio 19.1 on a fresh Windows 11 Pro installation.
From time to time, after connecting to my localhost\SQLEXPRESS ...
0
votes
0
answers
65
views
SSMS keyboard shortcut for save only the focused Query
I am running SQL Server Management Studio 19.1.56.0 with a project solution that has about 10 Queries. When I save, either with Ctrl+S or Ctrl+Shift+S and default keyboard shortcuts, SSMS will ...
1
vote
0
answers
226
views
Microsoft SQL Server Management Studio starts to consume 100% of CPU after a while when the VPN connection to the SQL Server is disconnected
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.
This question does not appear to be about programming within the scope defined in the help center.
...
0
votes
0
answers
214
views
Multiple values using the N prefix
I need to put multiple values in the @RefValue parameter to speed up the result:
I tried :
@RefValue = N'204' --205 '
however, it only returned the value of the register 204.
Command:
DECLARE @...
3
votes
0
answers
4k
views
Can't install ODBC Driver 17 for SQL server On Windows 11
i want install SSMS 19.1
this is stuck like picture
the problem for "microsoft ODBC Driver 17 for SQL Server" cant install
i download it manually and try install it but this error appear
0
votes
0
answers
466
views
SQL Server database upgrade - 2016 to 2019
We upgraded our SQL server from 2016 to 2019. Now we need to upgrade/convert our custom 2016 database to make it 2019 compatible. What's the process? We are running SQL Server management studio 2019 ...
1
vote
0
answers
199
views
copy ssms query result and paste as table in ms teams
is it possible to copy results from ssms results and copy that results into ms teams chat as table? What I do now is that I copy data from ssms into excel and from excel I copy into MS Teams. But I ...
1
vote
1
answer
3k
views
How to open SSMS as a different user using username and NOT using email address?
I am trying to run SSMS as a different user and it is not letting me run as a different user. It is asking for email address instead. How to get around this issue?
Thanks in advance.
I have tried ...
1
vote
1
answer
692
views
Why are my Database Diagrams now blank after upgrading to SSMS 18.12.1
I upgraded SSMS this morning to 18.12.1, but when I open my database diagrams all of them are displayed as blank pages.
How do I fix this?
-1
votes
1
answer
1k
views
Installing SSMS in Windows Core
I'm trying to: start "" /w ".\smss-setup-enu19.exe" /passive ssmsinstallroot="c:\program files\ssms" but encountering this error:↓ (syntaxes using " around path and ...
0
votes
0
answers
29
views
Save SQL Server 'Server Name' values when running SQL Server as user with different domain
So I need to periodically run SSMS as a user other than the windows user I am logged into my machine as. This user has a different domain than the user I am logged into my computer as, therefore what ...
0
votes
0
answers
265
views
copy-paste issue when using SSMS over GoToMyPC
I'm hoping someone here has run into this issue and knows if there's a fix for it.
When using GoToMyPC, I'm unable to copy text from the editor in SSMS (v14) on my remote desktop and paste it into the ...