Questions tagged [ssms]
SQL Server Management Studio is an IDE for administering Microsoft SQL Server.
117
questions
0
votes
1
answer
1k
views
SQL query to count each person's longest string of consecutive scores of 7
I've got a SQL table that looks like this (with the name in column A and the score in column B):
N. Name Score
1. Jim 7
2. Jim 4
3. Jim 4
4. Jim 7
5. Jim 7
6. Jim ...
0
votes
0
answers
427
views
Default to Windows Authentication for SSMS login
After launching SQL Server Management Studio 2012, the "Connect to Server" prompt is displayed. In the "Authentication" dropdown, it defaults to "SQL Server Authentication", which I have used in the ...
0
votes
1
answer
1k
views
SQL Server Management Studio (SSMS) 2012 slow to show results in Grid only
I generally use Microsoft SQL Server Management Studio 2012 (11.0.3000.0) with query results being displayed in a grid. As of 3 or 4 days ago query results have been quite slow, but only ...
0
votes
0
answers
2k
views
Unable to open SSMS from run window
I'm having an issues that bugs me and can't seem to be able to solve it. I have SQL Server 2005 and 2012.
For the 2005 instance this is my path (for both 2005 and 2012 the path that leads straight to ...
0
votes
1
answer
67
views
SQL server connects after browser restart
I am using SQL server 2008 trying to connect the server using management studio using ssms with server name including ports and named instance with SQl authentication . Windows firewall is disabled .
...
0
votes
1
answer
339
views
Why can't I select the font I want for the SSMS 2012 Text Editor?
I like to use the Source Code Pro font published by Adobe. When I try to change the font of the text editor in SQL Server Management Studio 2012 it doesn't appear in the list. If I select one of the ...
0
votes
1
answer
54
views
SSMS query editing: possible to remove a field and have the matching value removed?
I work with large queries in SSMS. It would be fantastic if I could easily match up the comma-separated values with the comma-separated field names. I often delete a field, and then have to hunt for ...
0
votes
1
answer
73
views
Check for unique rows, but ignore one particular column
I have an XML document, that looks like this:
Column A to S with headers, and there are 1922 rows.
This is an backup of some SMS, and I want to get rid of duplicates.
The problem is, that the Time ...
0
votes
1
answer
235
views
SQL Server Management Studio 2005 SQL dump
How can i create a SQL dump (structure and data) with the Management Studio 2005 or the MS SQL server?
-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 ...
-1
votes
1
answer
827
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 ...
-2
votes
1
answer
99
views
SSMS 18.2 gives error when performing DDL
We upgraded to SQL Server 2016 SP1 and SSMS 18.2 last week. Today I've been trying to execute DML in the database and am getting this error message:
Msg 208, Level 16, State 1, Procedure ...