The ssms tag has no wiki summary.
1
vote
0answers
21 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 ...
0
votes
1answer
91 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
85 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 ...
0
votes
0answers
65 views
Database Diagrams no longer work in SQL Server Managment Studio 2008 R2 SP1
When I go to open or create a new Database digram on a new or existing database I get the error.
The specified module could not be found.
(Diagram Surface)
I have searched endlessly on Google ...
-1
votes
2answers
45 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
35 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
22 views
SSMS 2008 Object Explorer issues on Server 2008
In SQL Server Management Studio 2008, when I have a query window open and I hover any items in the Object Explorer panel under Programmability that have a tooltip (happens when the panel's width is ...
0
votes
1answer
37 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
94 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
120 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
116 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 ...
