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

2
votes
1answer
319 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
106 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 ...
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 ...
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 ...
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 ...
0
votes
0answers
30 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
42 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
186 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
276 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 ...
0
votes
0answers
304 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 ...