Tagged Questions

SQL Server Management Studio is an IDE for administering Microsoft SQL Server.

learn more… | top users | synonyms

0
votes
0answers
14 views

Using Junctions (or directory link) to mirror profile for two different domains?

I have a weird setup at work. My computer is linked to two domains, one's the primary domain which I'm logged into 99.9% of the time. The other domain is primarily for SQL Server management (and ...
0
votes
1answer
9 views

Why can't I select the font I want for the SSMS 2012 Text Editor?

I like to use the Source Code Pro font published by Adobe. When I try to change the font of the text editor in SQL Server Management Studio 2012 it doesn't appear in the list. If I select one of the ...
1
vote
1answer
5k views

Clean reinstall SQL Server Management Studio

I am on Windows 8.1, Professional edition. I installed SQL Server Management Studio 2012 x64 and everything worked well. I installed Visual Studio 2013 and everything worked well. Then, I installed ...
0
votes
0answers
18 views

SSMS [script to clipboard] add to commands on panel

How to add [Obj-(rclick)-ScriptAs-CreateTo-Clipboard] command to panel? There is icon available on it but I cannot find it in Customize area.
0
votes
1answer
37 views

SSMS view designer - how do I give a table an alias?

I'm struggling with getting SQL Server Management Studio to do what I want. Things that were totally simple and easy tasks in Enterprise Manager have inexplicably become hard or impossible. Case in ...
2
votes
1answer
964 views

SQL management studio hangs when opening after being closed down on dual screen

I have a dual screen set-up. I'm running windows 8.1. I have had this issue with Management studio 2008 R2, 2012 and 2014. If I drag the management studio screen across to my 2nd display, and then ...
0
votes
0answers
118 views

Shift+Tab Loses Alignment in SQL Server Managment Studio 2012

Issue #1: I'm using the following for demonstration purposes: SELECT A.Field1, B.Field2 FROM TableA as A JOIN TableB as B ON B.ID = A.ID WHERE A.FieldA = 'A' AND B.FieldB = 'B' GROUP BY ...
0
votes
1answer
47 views

SSMS query editing: possible to remove a field and have the matching value removed?

I work with large queries in SSMS. It would be fantastic if I could easily match up the comma-separated values with the comma-separated field names. I often delete a field, and then have to hunt for ...
0
votes
0answers
45 views

Free Source Control for .sql files to run alongside SSMS

Does anyone use source control for there .sql files? My job revolves around a suite of approx 75 stored procedures in sql-server. I'm now sharing the development of these files with a colleague. ...
0
votes
0answers
34 views

Is there a way SQL Server Management Studio can be used to hook into ECM?

I have a SharePoint-based ECM (enterprise content management) system and am exploring storing code snippets (mainly T-SQL scripts). I'd like to be able to access the ECM through SSMS in a manner ...
1
vote
0answers
125 views

Changing font color in SSMS for different database elements?

I'm trying to change font color of different database elements, for database name to show up one color, table name to show up another and table aliases to be separate color. Is it even possible? ...
0
votes
1answer
150 views

Can't open SSMS - stating I don't have permissions

Whenever I try and run SSMS I get the following error. 'Windows cannot access the specified device, path or file. You may not have the approiate permissions to access the item. ' The dialog box ...
0
votes
1answer
30 views

Check for unique rows, but ignore one particular column

I have an XML document, that looks like this: Column A to S with headers, and there are 1922 rows. This is an backup of some SMS, and I want to get rid of duplicates. The problem is, that the Time ...
1
vote
1answer
46 views

SSMS 2008 is stuck because Connect to Server window is hiding

Launching SQL Server Management Studio 2008 after rdp or similar display config funny business, the Connect to Server window is sometimes hiding in the corner of a monitor. The program seems stuck, ...
1
vote
1answer
28 views

Is there any way to Start SSMS connected to registered server

Is there any way to start SQL Server Management Studio to connect to a registered server? I have managed to get it to start from the command line connecting to the desired DB with the use of the -S ...
1
vote
1answer
483 views

How can I connect to sql server from a different domain/network

I installed SQL Server 2008 R2 on 6 machines. They are to be placed in 2 offices, 3 in each. I created a database instance and I used VB6 and was able to link both perfectly. I was also able to ...
0
votes
1answer
75 views

SSMS starts without login prompt and stays inactive

recently my SSMS started working really weird, wasting my time. I am working on a laptop connected to additional monitor. SSMS starts without login prompt, and stays inactive as long as I dont shut ...
1
vote
1answer
32 views

Default text for SQL scripts

In MS SSQL Server Management Studio 2012, is it possible to get new scripts to contain some default text? I want to encourage colleagues to comment their scripts more consistently, so I'd like ...
0
votes
1answer
219 views

SQL server replication, subscription to remote server : issue while choosing the publisher

I am trying to create a subscription to a remote server having SQL 2008 R2 the client PC is connected through VPN to the server and can discover it successfully. I can even connect to the database ...
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 ...
0
votes
1answer
63 views

SQL Server Management Studio 2005 SQL dump

How can i create a SQL dump (structure and data) with the Management Studio 2005 or the MS SQL server?
1
vote
1answer
896 views

How do I change the default format for an date time value copied from SSMS to Excel

I often copy the results of a query from Sql Server Management Studio to Excel because I can fiddle with sorting and filtering of results faster using Excel's built in tools than by changing the query ...
3
votes
1answer
80 views

SSMS 2008 indent on line break

I'm tired of using Tab key when I pressed Enter and Tab Key in SSMS editor because when I have something like this: CREATE PROCEDURE SP_Example BEGIN SET NOCOUNT ON SET DATEFORMAT ...
1
vote
1answer
34 views

Reassign F11 in SSMS

Reassign function keys in ssms? Anyone know how? When I'm stepping through code I keep hitting F11 in SSMS on accident. Then have to cancel too many dialog boxes. I want to change F10-F12 to just run ...
12
votes
1answer
976 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 ...
3
votes
2answers
2k views

SQL Server Management Studio print in color

I am using SQL Server Management Studio 2012. I am trying to print a stored procedure in the color-coded syntax that it loves showing me, but cannot find an option to enable this. Any ideas? I know ...
1
vote
0answers
312 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
2answers
450 views

Installing Sql Server Mangement Studio on Windows XP

I am trying to install Sql Server Mangement Studio 2008 onto a Window XP SP3 machine. When I do, it says that I need to install .Net Framework 3.5 SP1. However, I all ready have .Net Framework 4.0 ...
5
votes
2answers
3k views

Sql Server Management Studio: Change Prefix or Suffix characters

I have an instance of SSMS 2008, for which the option to edit data in a table doesn't work. If I right-click on any table in the Object Explorer and select 'Edit top 200 rows' I get an error dialog ...
3
votes
3answers
885 views

Is it possible to enable Intellisense for SQL Server Management Studio Express 2012 (SSMS)?

I have installed SSMS to connect with my Old SQL Server 2005. Just want to test new features for new version of SSMS Express 2012. I use Right click on the Text Editor to enable Intellisense but I ...
1
vote
2answers
2k views

SQL Server Management Studio: Database Attachment Failed

I have publish my website in IIS7. It is running in DefaultAppPool. The Identity of this app-pool is set to LocalSystem. The IIS is running and I can run the application from IIS without any problem. ...
1
vote
2answers
923 views

Configuring VM with SQL Express to be accessed using SSMS from host

I'm trying to configure my VM with SQL Server 2008 R2 Express so that I will only be able to remotely access SQL using SQL Server Management Studio from host machine. VM configuration running ...
0
votes
1answer
2k views

SQL Server Management Studio: network-related or instance-specific error while establishing a connection to SQL server

SQL Server Management Studio: network-related or instance-specific error while establishing a connection to SQL server. Here's a screenshot of the error:
1
vote
0answers
207 views

How do I migrate my registered servers in SSMS from one machine to another?

How do I migrate my registered servers in SSMS from one machine to another? I tried copying %appdata%\Microsoft\Microsoft SQL Server\100\Tools\Shell over during my profile migration, but apparently ...
8
votes
3answers
20k views

How to Run an app as Administrator without the prompt?

When I start SQL Server Management Studio 2008, I an error that's been around forever and is documented here. One of the suggestions to fix it that actually worked was to start SSMS with Run as ...
5
votes
1answer
2k views

How are SQL server management studio passwords saved?

If, when connecting to a database with sql server management studio and you select "remember password"... where and how is it saved? I presume it is somehow encrypted using your windows login ...
6
votes
1answer
7k views

Anyway to use SSMS to connect to MySql?

I've grown to love SQL server management studio (ssms), I realise that it is not naturually compatible, however is there a way of connecting to MySQL? Perhaps using an ODBC connection? I realise ...
1
vote
2answers
3k views

How do I get a standalone SQL Server Management Studio (SSMS)?

I don't want to install the entire SQL Server (2005 or 2008) on my Virtual PC (saving space), yet I need the SSMS to connect to external databases. What are my options?
0
votes
4answers
717 views

Tool to copy SQL Server Database

I am looking for a tool to copy a sql database tables, stored procedures, functions etc and also the data contained within the database from a server to my local pc. Both have sql server management ...
2
votes
1answer
2k views

Installing SQL server express 2008 SP1 on Windows 7

I'm installing (well trying to) SQL server express 2008 SP1 on Windows 7 This is not working for me. I started by installing VS2010 B2, it installed SQL 2008 Express. I went into the 'SQL Server ...
1
vote
1answer
3k views

Avoid “The source conrol provider associated… could not be found” message in SSMS

Every time I open my *.ssmssqlproj in SSMS i get the message: The source control provider associated with this solution could not be found. The projects will be treated as not under source ...