Questions tagged [ssms]
SQL Server Management Studio is an IDE for administering Microsoft SQL Server.
117
questions
5
votes
2
answers
8k
views
SQL Server Management Studio print in color
I am using SQL Server Management Studio 2012. I am trying to print a stored procedure in the color-coded syntax that it loves showing me, but cannot find an option to enable this. Any ideas?
I know ...
4
votes
2
answers
12k
views
Unblocking Windows 10 Defender Firewall for MS SQL Server 2014
I have an instance of MS SQL Server 2014 (call it MSSQL) on a Windows 10 machine (call it WINTEN).
Running SSMS on WINTEN, I can connect to both the local SQL Server and also to SQL Server instances ...
4
votes
3
answers
2k
views
Is it possible to enable Intellisense for SQL Server Management Studio Express 2012 (SSMS)?
I have installed SSMS to connect with my Old SQL Server 2005. Just want to test new features for new version of SSMS Express 2012. I use Right click on the Text Editor to enable Intellisense but I can'...
3
votes
1
answer
3k
views
Installing SQL server express 2008 SP1 on Windows 7
I'm installing (well trying to) SQL server express 2008 SP1 on Windows 7
This is not working for me.
I started by installing VS2010 B2, it installed SQL 2008 Express.
I went into the 'SQL Server ...
3
votes
1
answer
1k
views
Is there a way to make the I-beam cursor bigger or thicker in Windows?
Is there a way to make the I beam cursor bigger or thicker in Windows? I can make the regular cursor (arrow) larger by using a different .cur file. In some windows like the query window in SQL Server ...
3
votes
1
answer
2k
views
How do I change the default format for an date time value copied from SSMS to Excel
I often copy the results of a query from Sql Server Management Studio to Excel because I can fiddle with sorting and filtering of results faster using Excel's built in tools than by changing the query ...
3
votes
1
answer
125
views
SSMS 2008 indent on line break
I'm tired of using Tab key when I pressed Enter and Tab Key in SSMS editor because when I have something like this:
CREATE PROCEDURE SP_Example
BEGIN
SET NOCOUNT ON
SET DATEFORMAT ...
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
2
votes
1
answer
4k
views
SSMS wont give up file associations
Apparently this is a known Win10 bug and should hopefully be fixed in an upcoming update.
I have installed SQL Server Management Studio v17.9 on a clean Windows 10 installation. This associated all ....
2
votes
1
answer
3k
views
Always encrypt connection from SQL Server Management Tool
I've noticed that the "Encrypt connection" checkbox seems to default to unchecked.
Is there a way to default this to being checked?
2
votes
1
answer
287
views
Apex SQL complete freezes SQL management studio
I am using SSMS 18.4
I installed APEX sql complete, and every 30 minutes it freezes my management studio.
So I'd have to go to Task Manager and end it from there.
Did anybody have issues like ...
2
votes
2
answers
2k
views
Configuring VM with SQL Express to be accessed using SSMS from host
I'm trying to configure my VM with SQL Server 2008 R2 Express so that I will only be able to remotely access SQL using SQL Server Management Studio from host machine.
VM configuration
running ...
2
votes
0
answers
30
views
Preserve shortcuts in SSMS after restart
I use SQL Server Management Studio in this version:
Microsoft SQL Server Management Studio 14.0.17289.0
Microsoft Analysis Services Client Tools 14.0.1016.283
Microsoft Data Access Components (...
2
votes
0
answers
239
views
SSMS 18.5 installation
I'm a bit of a novice and struggling to install SSMS on my PC. I have recently had to reinstall Windows 10 and now cannot get SSMS to install.
I have downloaded the latest version of SSMS from ...
2
votes
0
answers
543
views
Sql Server Management Studio 18.1
I recently installed SSMS 18.1 and I am having an issue when trying to drag and drop table names from the object explorer to the query window. For example, I am writing a query and dont want type out ...