Questions tagged [sql-management-studio]
The sql-management-studio tag has no usage guidance.
50
questions
0
votes
0
answers
62
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
111
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
0
votes
1
answer
194
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
257
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
28
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
244
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
86
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
247
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
768
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
272
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 ...
- 143
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
6k
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
2k
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
30
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?
- 424
2
votes
1
answer
9k
views
How to fix font size issues in management studio
Under my Windows 10 Pro Version 1607 Build 14393.321 i recently ran in into font-size issues inside of management studio (see screenshots below).
I am not certain if the cause of the "font-size ...
- 275
8
votes
3
answers
3k
views
SMS slow when connecting to Azure SQL Server
I host 2 databases on Azure SQL Server Db. Two very small 40Mb databases. Very limited access to them. If I look at my DTU, its like 0 peaking at 5%.
However when ever I open either of the databases ...
- 201
2
votes
2
answers
3k
views
SQL : Restrict view of tables in database
This is probably a no but, I want to be sure. A client wants to connect to SQL Server 2008 that we host. They will be accessing a table to execute an SSIS package to copy some data they have on their ...
- 21
1
vote
0
answers
131
views
Disproportionate windows in SQL Server Management Studio
Some windows are of a disproportionate size in SQL SSMS and I need to reset them. They're so big that many of the text boxes overlap each other and practically make it unusable. I have recently ...
- 11
0
votes
1
answer
2k
views
Computer restarts while using Visual Studio 2012
I have Windows 7 Enterprise edition and I have installed Visual Studio 2012 and Microsoft SQL Server 2014 Management Studio. Whenever I start Visual Studio to work on my project the computer restarts ...
- 103
1
vote
1
answer
116
views
Can I share registered servers across multiple copies of Microsoft SQL Server Management Studio?
In Microsoft SQL Server Management Studio 2014, I use Registered Servers to save all my database connections that I use on a daily basis. I am looking to find a way I can save the settings of these ...
- 187
2
votes
1
answer
318
views
Microsoft SQL Server Management Studio sometimes Sees but other times Fails to See
My computer has the following Software involved.
Microsoft Windows 7
Microsoft SQL Server 2008 R2
Microsoft SQL Server Management Studio
Moreover, I have the following Drive partitions:
C: drive
...
- 263
-2
votes
1
answer
66
views
How to install MS SQL Management Srudio for SQL Server 2008?
I have downloade SQLManagementStudio_x86_ENU.exe file, but when I run it, it starts global SQL server 2008 installer where I can't find any signs of Management Studio.
- 12.5k
0
votes
2
answers
865
views
Copy line numbers from SQL Server Management Studio
In SQL Server Management Studio, I've configured the Text Editor to show the line numbers, like so:
I want to move these into a word document for documentation. Right now if I were to highlight this ...
5
votes
1
answer
2k
views
Copying out color theme background from SQL management studio to Outlook
I have a color theme set in SMS 2012, where the background is dark and some of the syntax is white, when I copy and paste this out into an email (white background) the dark background of management ...
- 151
0
votes
1
answer
3k
views
Assign login to SQL user without login
Environment: SQL Server 2012 Express Edition and Microsoft SQL Server Management Studio. All users are local SQL users, NOT Windows authentication.
I attached a database file which came from another ...
- 3,752
0
votes
1
answer
104
views
Edit sql code instead of clicking buttons
Does SQL Management Studio 2012 allow editing the SQL DDL (data definition language) code directly? If not, how can I view only the SQL code generated by the application?
- 121
1
vote
2
answers
6k
views
Errors during installation SQL Server Management Studio (ssms) on 64-bit Windows7
I have been trying to install SQL Server Management Studio (ssms) on a 64-bit Windows7 for two days now and it just doesn't work.
On a otherwise completely clean 64-bit Windows7 system I get the ...
- 1,347
23
votes
4
answers
15k
views
Floating or vertical results pane in SQL Server Management Studio
I have a multi monitor configuration and would like to be able to have my query editor on one monitor and the results pane on another.
Can this be achieved? Either by having the results pane ...
- 16.6k
2
votes
1
answer
2k
views
Loading Files from My User Directory in SQL Server Management Studio 2012 Under Windows 8
I'm in the process of migrating to Windows 8, part of which was to get SQL Server/SQL Server Management Studio 2012 running. I tried to load some sample data from a .bak file for a 2012 compatible ...
- 420
0
votes
1
answer
7k
views
Microsoft SQL Server Management Studio not working after installing .Net Framework 4
Yesterday I installed .Net Framework 4 as it was required by Liquid XML Studio, but just after installing it, My SQL Server Management Studio stopped working. As soon as open the IDE I get
package ...
0
votes
2
answers
8k
views
Why Intellisense doesn't work in SQL Server Management Studio 2008 R2? [closed]
I have SQL Server Management Studio 2008 R2.
I have tried these:
Tools->Options->Query Execution->SQL Server->General, make sure “By default, open new queries in SQLCMD mode” is unchecked
Go to ...
William
1
vote
1
answer
4k
views
SQL Server 2008 Management Studio - Edit Rows with Where clause
There is an option to edit rows in a grid - first 200 by default.
In Tools -> Options -> Sql Server Object Explorer, you can set the value for "Edit Top N rows".
I have a table with 200000 rows....
- 2,082
5
votes
3
answers
4k
views
Can I install Microsoft SQL Management Studio by itself?
I installed Visual Studio 2010 on my machine and it installed along with it SQL Server Express 2008.
Now I'd like to use the Management Studio, but I can't seem to find it so I assume it doesn't ...
0
votes
0
answers
2k
views
Cant create table using Microsoft SQL Server Management Studio Express
When I try to add table do database I get window with this error:
===================================
Nieokreślony błąd. //that means Unspecified Error
(MS Visual Database Tools)
------------------...
- 186
1
vote
1
answer
117
views
When selecting a recent file from the application context menu in windows 7, the program opens, but does not open the selected file?
What gives? when I mouse over sp_profileColumn.sql and left click; Management studio opens but doesn't load the file?
- 473
7
votes
3
answers
6k
views
SQL Server Management Studio 2005 - Set Default Encoding
Is anybody aware of a way to set the default encoding when saving a file to in SQL Server Management Studio to be ANSI instead of Unicode? Our source control system/diff tools barf when it runs ...
- 255
0
votes
2
answers
9k
views
How do I write a query in Microsoft SQL Server Management Studio and then use that Query in Excel
I have an Excel file that I want to open up, hit refesh, and it pulls in the data from the SQL server and then I manipulate the data and create some dashboards. I actually have this but I'm pulling ...
- 526
7
votes
5
answers
32k
views
try to attach to a database file but can't browse folder which contains the file
I am trying to attach to database file (*.mdf, *.ldf) that I placed in the same folder as all my other SQL Server databases. I begin the attach by attempting to browse to the folder which contains the ...
- 2,144
10
votes
2
answers
23k
views
SQL Server Management Studio Color Schemes?
Is there a way to apply color schemes and themes to SQL Server Management Studio? I really enjoy the ones for Visual Studio 2005/2008/2010 and would love to have something like that.
Color Schemes ...
- 2,029
1
vote
2
answers
617
views
Northwind Database
How can I Install Northwind Database in SQL Managment Studio 2008 R2?
Specification: Microsoft Windows XP Service Pack3 2002 version
Shyam
1
vote
2
answers
1k
views
SQL Server Management Studio Express - include date/time in Results or Messages
In SQL Server Management Studio Express 2005 is it possible to output the date and time that a query completed in the Results or Messages windows?
(without having to manually add a SELECT Getdate() ...
- 16.6k
50
votes
8
answers
98k
views
Is it possible to open a SQLite database from within Microsoft SQL Server Management Studio?
Is there a way to open a .db file (SQLite database file) from within Microsoft SQL Server Management Studio?
Right now we have a process that will grab the data from a Microsoft SQL Server database ...
- 1,081
2
votes
1
answer
1k
views
Sql Server Managmenet Studio Alternative - Are there any?
I am looking for lightweight MS SQL Server Managmenet Studio (2005) alternative (open source/freeware is a bonus). Something more like HeidiSQL for MySQL.
LINQPad is not an option (although it's ...
- 841
2
votes
3
answers
2k
views
Why does MS SQL Server Management Studio almost freeze up my computer while it restores?
Why does MS SQL Server Management Studio almost freeze up my computer while it restores? It makes it so when I click on the clock it takes seconds for the calendar to open. I don't see why this ...
josh
3
votes
1
answer
3k
views
Unspecified Error in Sql Server Management Studio
I just started getting an error window with "Unspecified Error" in MS Sql Server Management Studio 2005. I get this when trying to Create a New Table in a DB or Right Click > Design on an existing ...
- 390
2
votes
1
answer
739
views
How can I add a keyboard shortcut for Find-In-Files in SQL Server Management Studio?
I'd like to make it Ctrl-Shift-F to match Visual Studio.
I realize to do that I need to remove that binding from the Query->Save to File item.
But, I can't even add ANY shortcut. When I pull up the ...
- 133
5
votes
4
answers
939
views
SQL Server 2005 Management Studio is Slower than Molasses!
SQL Server Management Studio 2005 is so slow that I often want to use something command-line just so I can move on with my life and quit waiting for the stupid GUI to load. Have you ever run an ...
- 875
3
votes
3
answers
4k
views
SQL Server Linux admin tools
I would like to know if there is sql server tools for linux?
eg. tools like sql server enterprise manager.
- 2,021
19
votes
2
answers
67k
views
Connect to an MS Access Database from SQL Management Studio
I want to connect to an MS Access 2003 DB from SQL Management Studio 2005 so I can run queries on the Access DB from SQL Management Studio.
- 727