Super User Stack Exchange
Super User Stack Exchange

Questions tagged [sql-management-studio]

50 questions
49
votes
8 answers

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 and put it into a SQLite database file that will be…
Brian T Hannan
  • 1,071
  • 4
  • 15
  • 26
23
votes
4 answers

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 vertically attached to the query editor instead of…
Shevek
  • 16,502
  • 7
  • 46
  • 75
19
votes
2 answers

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.
John Oxley
  • 727
  • 4
  • 12
  • 23
10
votes
2 answers

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 for Visual Studio: Create and share Visual Studio…
spong
  • 2,029
  • 6
  • 28
  • 40
8
votes
3 answers

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 in SQL management studio 2016. (v13.0.15600.2) It…
Zapnologica
  • 201
  • 4
  • 9
7
votes
3 answers

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 across a Unicode file format. I've googled a possible…
Jim B
  • 255
  • 3
  • 8
7
votes
5 answers

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 db files as well as all of my active database…
Ivan
  • 2,094
  • 9
  • 29
  • 41
5
votes
1 answer

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 studio is not copied with it, meaning you can't see…
Oli Fletcher
  • 151
  • 3
5
votes
4 answers

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 update command and have the entire window lock up on…
Josh Stodola
  • 865
  • 3
  • 11
  • 30
5
votes
3 answers

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 install it without installed the SQL Server by…
Only Bolivian Here
  • 749
  • 3
  • 12
  • 21
3
votes
3 answers

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.
mnml
  • 2,001
  • 4
  • 23
  • 28
3
votes
4 answers

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 file type association setup, it doesn't show…
natenho
  • 166
  • 1
  • 2
  • 7
3
votes
1 answer

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 table. I am able to open up a new connection and…
Yaakov Ellis
  • 390
  • 6
  • 18
2
votes
1 answer

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 D: drive E: drive Therefore, when I created the…
user1338998
  • 263
  • 1
  • 7
2
votes
1 answer

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 Tools/Customize box, pick Edit in the Categories…
Eric H.
  • 133
  • 4
1
2 3 4