The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
20 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: ...
-2
votes
1answer
27 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.
0
votes
1answer
58 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 ...
0
votes
1answer
261 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 ...
0
votes
1answer
73 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?
1
vote
2answers
2k 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 ...
12
votes
1answer
893 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 ...
1
vote
0answers
303 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 ...
0
votes
1answer
3k 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
3k 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 ...
1
vote
1answer
3k 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
2k 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
815 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
98 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?
5
votes
3answers
3k 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
5k 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 ...
5
votes
5answers
10k 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 ...
9
votes
2answers
14k 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
549 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
840 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
votes
5answers
13k 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 ...
2
votes
1answer
869 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
1k 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 ...
3
votes
1answer
1k 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
434 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
819 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 ...
1
vote
2answers
1k 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.
11
votes
2answers
24k 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.