Questions tagged [sql-management-studio]
The sql-management-studio tag has no usage guidance.
50
questions
1
vote
0
answers
233
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.
...
- 11
0
votes
0
answers
113
views
Windows 10 2004 error saving passwords
after the win10 2004 update I got this behavior:
seems that all the 'Microsoft' programs and some other doesn't' save the user passwords:
visual studio 2019, every time I open it show me to sign in: ...
- 101
1
vote
1
answer
533
views
SQL Server started, but SQL Server Management Studio not connecting to it
Problem statement
I have installed (Developer Edtion) and started my SQL Server, but when trying to connect to it through SQL Server Management Studio, it shows this error:
My configuration for SQL ...
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 ...
- 138
0
votes
0
answers
29
views
Why is SQL Management Studio Stored Procedure breaking my rows into new lines?
I have a stored procedure that is set up to run once a week. However, it seems to be breaking up my lines if the length of the row is over 224 characters, right in the middle of words. The procedure ...
0
votes
0
answers
305
views
Trying to connect to SQL Server through SQL Server Management Studio for the first time won't connect
Hey all so my problem is that I try to connect before even accessing the object explorer or anything and have ended up with this error. I've tried using Windows Authentication which is what I want to ...
- 1
0
votes
0
answers
112
views
Issue with Microsoft SQL server management studio 2019
When i installed Microsoft SQL server management studio it runs properly with no issue but i have installed XAMPP for mysql on my system but when i run it afterwards SQL server does not working.
does ...
0
votes
1
answer
267
views
SQL server 2016 connecting to SQL Management Studio
I am using a SQL Server Management Console and the SQL Server 2016 Evaluation edition trying to connect a local server on Windows 10. I am connecting to an Azure cloud instance cluster because I have ...
0
votes
1
answer
1k
views
Rename SQLServer instance after rename computer
I have SQL Server 2012 running on Windows Server 2012. I renamed the Windows Server and need to adjust the SQL Server for the new name to get my Maintenance Plans running.
When I run Select @@...
- 121
1
vote
0
answers
810
views
Can't connect to database in SSMS 2017
I used to be able to connect, and now I can't. I have tried uninstalling and reinstalling SSMS. I have not changed my antivirus/firewall settings at all.
OS: Windows 10 Home
TITLE: Connect to Server
...
- 1,182
2
votes
2
answers
365
views
How to trigger SQLServer suggestion popupmenu
I have a very big job to do on a very large SQLServer DB, with unusually large table names.
Having the popup menu suggesting the names of the tables and such, would really come in handy, but it ...
- 163
0
votes
2
answers
1k
views
Restore Failed for server; Cannot open backup device; The system cannot find the file specified
I am trying to restore a database in sql server management studio in sql 2008 using these steps:
Open SQL Management Studio.
Right Click on Databases.
Choose "Restore Databases..."
Enter a "To ...
3
votes
4
answers
7k
views
SSMS 2017 - How to restore .sql file association?
After installing SQL Server Management Studio 2017 and uninstalling SSMS 2016, Windows 10 shows the "How do you want to open this .sql file" screen every time I try to open a sql file.
When I look at ...
- 166
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?
- 133
1
vote
1
answer
32
views
how to launch SQL Management Studio with SA auth mode instead of Windows Auth
When ever I launch SQL Management Studio 2014, its connect window opens up with Windows Authentication by default. How do I make it so it should show SA authentication by default?
- 434