Questions tagged [ssms]
SQL Server Management Studio is an IDE for administering Microsoft SQL Server.
117
questions
1
vote
1
answer
89
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 -...
- 175
2
votes
1
answer
2k
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 ...
- 21
0
votes
2
answers
1k
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 ...
- 3
1
vote
1
answer
61
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 ...
- 355
1
vote
1
answer
1k
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 ...
- 36
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,377
0
votes
1
answer
235
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?
- 103
3
votes
1
answer
2k
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
1
answer
125
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 ...
- 205
1
vote
1
answer
246
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 ...
- 601
23
votes
4
answers
16k
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.7k
5
votes
2
answers
8k
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 ...
- 439
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 ...
- 450
0
votes
2
answers
2k
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 ...
- 379
8
votes
2
answers
15k
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 '...
- 1,009