The sql-management-studio tag has no wiki summary.
0
votes
1answer
239 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
2answers
291 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 ...
0
votes
1answer
236 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 ...
4
votes
3answers
218 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
0answers
348 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)
...
1
vote
1answer
82 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?
3
votes
2answers
640 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 ...
0
votes
2answers
1k 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 ...
3
votes
3answers
2k 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 ...
3
votes
2answers
3k 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 ...
1
vote
2answers
401 views
Northwind Database
How can I Install Northwind Database in SQL Managment Studio 2008 R2?
Specification: Microsoft Windows XP Service Pack3 2002 version
1
vote
2answers
586 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() ...
7
votes
4answers
3k views
Is it possible to open a sqlite database from within microsoft sql management studio?
Is there a way to open a .db file (sqlite database file) from within microsoft sql management studio?
Right now we have a process that will grab the data from a microsoft sql server database and put ...
1
vote
1answer
682 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 ...
2
votes
3answers
647 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 ...
1
vote
1answer
729 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 ...
2
votes
1answer
160 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 ...
5
votes
4answers
509 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 ...
6
votes
1answer
6k 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.
