The ssms tag has no wiki summary.
0
votes
0answers
45 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
20 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 ...
2
votes
1answer
109 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
46 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
23 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
39 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
110 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
148 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
56 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
49 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
29 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
63 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
113 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
173 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
152 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 ...
