SQL Server Management Studio is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server.

learn more… | top users | synonyms

-1
votes
1answer
36 views

Connect to SQL Server from different network (remote) [closed]

I am new to SQL server stuff and recently thought of creating a Database for my website. I would like to stop things like comments, blog post, stuff like that. But I am trying not to pay for SQL ...
0
votes
0answers
29 views

SQL Server Management Studio Import Wizard

I am trying to import a small excel spreadsheet into SQL using the SQL Server Management Studio Import Wizard, which is running on the Windows server (2008 R2) itself. When clicking "Import Data" from ...
0
votes
0answers
38 views

Cannot login to Reporting Services through SSMS and Reporting Services Configuration manager

I am trying to connect to reporting services through ssms. I am getting a following error: "A connection to the computer cannot be established. Access is denied" I have system administrator/system ...
0
votes
0answers
8 views

Is there a way in SSMS to change the default window layout in sub windows?

Over the past 10+ years, every time I open Design Table, Job History or many other windows, I have to adjust the split to show more in the bottom panel. Job Run length is just not visible in the Job ...
0
votes
0answers
168 views

SQL Server keep crashing, cannot connect with SSMS, Agent not starting

System Windows Server 2003 x64 SQL Server 2005 x64 Problems: 1) Cannot connect via SSMS - Tried both sa account and domain account (that is in sysadmin group) - If I supplied the wrong password, ...
0
votes
0answers
242 views

How do I permanently add additional connection parameters in SQL Server Management Studio

In the "Additional Connection Parameters" tab of the login form for SQL Server Management Studio (most recent versions), one may specify custom connection string parameters. See ...
1
vote
0answers
93 views

Alternative method of viewing a database diagram in SQL Server to see what tables have gone missing? [closed]

I have a database diagram for my database, but when I open it in SQL Server, I almost immediately get a message saying some permissions changed or tables in the diagram were dropped or renamed, and ...
-1
votes
1answer
51 views

SQL Server Maintenance Plan Wizard

Using SQL Management Studio 2012, when I right-click on an existing Maintenance Plan, and select the "Maintenance Plan Wizard" option from the context menu, what launches is a wizard to create a new ...
0
votes
2answers
23 views

Looking for SSMS 2008 Express Only

I downloaded SQL Server 2008 Express from here..... But it still did not install the SQL Server Management Studio that I need to connect to my databases.....see image below....looking for this. ...
0
votes
1answer
103 views

SQL server management studio 2005: Still can't copy column headers(checked option to include it already)!

I already changed the option to include column headers(Tools->option->results to grid->include column headers). Yet if I copy paste a Table or SQL query grid data results into Excel, i don't export ...
0
votes
1answer
157 views

What happens if a stored procedure is run in SSMS and it crashes?

What happens if a stored procedure is run in sql server management studio (SSMS 2012 to 2005 server) and it crashes? I'm guessing the stored procedure continues to run? On the other hand I have read ...
1
vote
0answers
36 views

ssms script wizard not working with modified tables

I'm looking for a way to get all triggers and constraint we modified in a script to migrate them to a different database or reapply to this one if necessary. I'm using SQLServer Management Studio ...
1
vote
0answers
39 views

What does this setting do when copying SSIS packages? “Duplicate package folder structure on destination for selected packages”

What does this setting do for copying SSIS packages? "Duplicate package folder structure on destination for selected packages." Is there any reason why I wouldn't want to duplicate the folder ...
0
votes
0answers
294 views

SQL Server Management Studio 2008 won't open

I'm trying to open SQL Management Studio 2008 to attempt to work with a server I have just set up, and to import an .sql file, but for some reason when I attempt to install and run the software it ...
2
votes
2answers
69 views

SSMS import large table

I'm trying to move several tables of data between 2 MSSQL 2008 databases, I have generated data insert scripts for one table which is quite large (around 3.5M rows) The script is around 3GB. When I ...
3
votes
1answer
529 views

Is SQL Management Studio 2012 avaliable, without Engine itself?

On my dev machine, I have SQL Management Studio 2008 R2 installed. I tried to upgrade to SSMS 2012 Express, setup finished but nothing happened. Is it possible to get SQL Management Studio 2012 ...
1
vote
1answer
94 views

Why does SQL Server Management Studio fail to connect on the first attempt?

When accessing SQL server on a remote development PC via Management Studio the connection will consistently fail on the first attempt. After the failure I retry and can now successfully connect to the ...
0
votes
1answer
81 views

How to restoring the Registered Server window in SQL Server Management Studio

Is there some way to restore the Registered Server window in SSMS ? I don't mean restoring the individual server details, rather I mean the actual window I've tried clicking the menu item "View \ ...
1
vote
0answers
86 views

SQL Server Management Studio Issue

I am trying to run a query on my hosting database. I can connect to the server just fine, but when I open the query window, the bottom says "Disconnected". When I right click on the query window and ...
2
votes
1answer
316 views

Viewing history for Maintenance Plan causing out of memory exception

I am trying to view history for a maintenance plan but keep getting an out of memory exception. It seems that the problem is that SSMS can't access memory beyond the ~3gb range. I've tried to find an ...
0
votes
1answer
2k views

SQL Server 2012 - where is Management Studio?

I recently downloaded and installed the RC0 of SQL Server 2012. I followed the installation process as usual, however - I can't seem to find SQL Server Management Studio (ssms.exe). Where can it be ...
-1
votes
2answers
2k views

SQL Server: How to edit a view without scripting it?

How can i edit the definition of a view without having to "script" it in SSMS? The previous easy-to-use tools from Microsoft let me: Enter wait a moment Make change Carefully move mouse to large OK ...
1
vote
0answers
92 views

How to create an SSIS package with a Script Component

I am using Microsoft Business Intelligence Development Studio (BIDS) to create an SSIS package. Take into account that is my first attempt with SSIS. I want to take data from a Source database ...
1
vote
2answers
897 views

Results copied from SSMS splitting across columns when pasted into Excel

SSMS 2008 -> Excel 2003 This isn't happening all the time, but sometimes when I 'copy with headers' from sql server management studio, the results in Excel look as though I've used the 'text to ...
2
votes
2answers
186 views

How To Backup A Maintenance Plan

I'm using SQL Server Management Studio 2005, and I'm about to make changes to the (rather important) Maintenance Plan. I would like to backup (or export) the Maintenance Plan, so it can be restored ...
2
votes
1answer
1k views

Hide database from other users in SQL Server 2008

I have created a database in SQL Server 2008 and it shows in server object explorer to all users that can login to SQL. I want to hide it from those users, I want it to be viewable by me only. How ...
2
votes
1answer
364 views

What permissions does SSMS Intellisense rely on?

We have a server on which SQL Server 2008 is running. When we connect to it with SSMS with some logins (from SSMS 2008), Intellisense is available. For others it isn't. The logins in question connect ...