Questions tagged [ssms]
SQL Server Management Studio is an IDE for administering Microsoft SQL Server.
117
questions
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 ...
- 51
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 ...
- 101
0
votes
1
answer
816
views
Windows 7: unable to copy-paste directory path in "Save File As" dialogue box
I am attempting to save a .sql file from Sql Server Management Studio to a non-default directory location. I would like to be able to copy the directory path from an open Explorer window and paste it ...
- 129
1
vote
0
answers
152
views
SSMS2012 Help going to Chrome rather than MSIE
Running Win7 Ent 64bit
From within SSMS 2012 SP2, when I hit F1 (or Help, View Help), I am taken to Google Chrome rather than MSIE11. By every indication I can find, MSIE11 is my default browser, not ...
- 126
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 .
...
- 823
1
vote
0
answers
782
views
SSMS and SSDT requires administrator
I connect to a client's Server (Server 2012R2) via RDP.
I always get the UAC prompt when I start the SQL tools, managemant studio (SSMS) and data tools (SSDT). If I press cancel in the UAC dialog the ...
- 295
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 ...
- 2,309
13
votes
5
answers
42k
views
Clean reinstall SQL Server Management Studio
I am on Windows 8.1, Professional edition. I installed SQL Server Management Studio 2012 x64 and everything worked well. I installed Visual Studio 2013 and everything worked well.
Then, I installed ...
- 421
1
vote
1
answer
383
views
SSMS view designer - how do I give a table an alias?
I'm struggling with getting SQL Server Management Studio to do what I want. Things that were totally simple and easy tasks in Enterprise Manager have inexplicably become hard or impossible.
Case in ...
- 930
18
votes
8
answers
33k
views
SQL management studio hangs when opening after being closed down on dual screen
I have a dual screen set-up. I'm running windows 8.1. I have had this issue with Management studio 2008 R2, 2012 and 2014.
If I drag the management studio screen across to my 2nd display, and then ...
user218317
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 ...
- 103
1
vote
0
answers
620
views
Changing font color in SSMS for different database elements?
I'm trying to change font color of different database elements, for database name to show up one color, table name to show up another and table aliases to be separate color. Is it even possible? ...
- 703
1
vote
1
answer
1k
views
Can't open SSMS - stating I don't have permissions
Whenever I try and run SSMS I get the following error.
'Windows cannot access the specified device, path or file. You may not have the approiate permissions to access the item. '
The dialog box ...
- 324
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 ...
1
vote
1
answer
166
views
SSMS 2008 is stuck because Connect to Server window is hiding
Launching SQL Server Management Studio 2008 after rdp or similar display config funny business, the Connect to Server window is sometimes hiding in the corner of a monitor. The program seems stuck, ...
- 125