The ssms-2008 tag has no wiki summary.
0
votes
4answers
2k views
Merge mulitple databases into single database with multiple schemas in SQL Server 2008
I have five smallish databases all within a single SQL Server 2008 instance. The databases are related (by business entity but not by data) so I'd like to merge them into a single database and give ...
0
votes
0answers
14 views
Using SSMS, how do I add a row to when a column is read only?
How do I add a row to when a column is read only? I think this issue I am having is because I am using an ID field (column) that is automatically generated and incremented whenever a new row is added ...
2
votes
0answers
532 views
Weird bug when copying from sql server management studio to excel in windows 7
I run a query in SQL management studio (results to grid), then select all results and copy with headers. Then I paste into Excel.
The result: two specific records are put together on one row in ...
5
votes
7answers
7k views
Activity monitor is unable to execute queries against server
Is there any fix to get SSMS activity monitor working?
Problem:
SQL Server Activity Monitor fails with an error dialog:
TITLE: Microsoft SQL Server Management
Studio The Activity Monitor is
...
0
votes
1answer
28 views
MS SQL Server 2008 R2 downloads for practice
I plan to download MS SQL Server 2008 R2 SP1 - Express Edition. I know I need one of the two applications to download with it: 1) SQL Server 2008 R2 Express with Tools and 2) SQL Server 2008 R2 - ...
1
vote
2answers
308 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
54 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 ...
1
vote
3answers
623 views
sql server management console doesn't work with multi-byte characters
I'm trying to work out how to use SQL server management studio properly with multi-byte unicode characters. even something as simple as:
select N'动漫'
just returns square boxes in the result pane. I ...
1
vote
1answer
49 views
How do I see processes from all users in SSMS2008?
I only see my own connections/processes in the new activity monitor... whereas in the earlier versions of SSMS you could see everyone's. Do I need to change a setting or something?
3
votes
1answer
188 views
SSMS: Where does SQL Server store its server names?
I have a number of "old" servers or server names with a typo in them that keep showing up in my dropdown list of server in the "Connect to Database" dialog of SQL Server Management Studio:
Where ...
0
votes
2answers
616 views
Can't connect to MS SQL Server database using SSMS
I have a database on line with Godaddy (who uses SQL Server 2005). They provide basic management tools, but tell you that for more advanced tools you can connect directly using SSMS. I followed their ...
0
votes
1answer
248 views
SSMS 2008 - Can't Add Maintenance Plans
Trying to save a new Maintenance Plan using SSMS 2008 and receiving error:
Apply to target server failed for Job 'DB Backup.createDBBackup'
The connection has been verified.
Is ...
2
votes
4answers
541 views
Is allowing remote Sql Server Management Studio safe?
I administer a website that runs on IIS on one box, and SQL Server 2008 Workgroup on another box. typically I remote into the DB box and run SSMS to work on the db, but I would like to be able to ...
0
votes
0answers
215 views
SSMS 2008 IDE response is VERY slow
While coding in SSMS 2008, IDE response is very slow.
For example a) Intellisense either stops suggesting or takes too much time to suggest values (hangs for 5 secs everytime) and on selecting ...
2
votes
2answers
551 views
SQL Server 2008 (SSMS) : Find next run date for a job
I would like to know if there is a way to get the next time a job is supposed to be running in SQL Server 2008, using a T-SQL query or even in SSMS if possible, without having to consult all the ...
1
vote
2answers
2k views
How to schedule a database backup operation by using SQL Server Management Studio in SQL Server 2008R2?
I'm having difficulties to setup a daily backup schedule in SSMS 2008 R2 Developer Edition.
This is exactly what I'm trying to achieve: My SSMS connect to my DB (remotely), which located at some ...
1
vote
1answer
2k views
“SQL Server 2008 Management Studio failed to load” after upgrading to Windows 7
I upgraded from Vista to Windows 7 and since then the SQL Server 2008 SP1 Management Studio Package is broken. Whenever I start it, it just shows the message "Package 'Microsoft SQL Management Studio ...
3
votes
2answers
3k views
How to install Microsoft SQL Server 2008 Management Studio Express
I have Microsoft SQL Server 2008 Express Edition already installed, and now I want to install SQL Server 2008 Management Studio Express.
I've tried with the only two options that look feasible:
...
1
vote
1answer
784 views
Viewing a large field in a query in SQL management studio with ZOOM?
Can anyone help? I am using SQL management studio (sql server 2008) to run queries and some of the fields that come back are varchar(max) for example and it has a lot of information - Is there a zoom ...
0
votes
1answer
10k views
How do I connect to NAMED INSTANCE of SqlServer 2008 running on custom port from another network?
I have a named instance of MS SQL Server 2008 running on port 1456. TCP/IP and NamedPipes are ENABLED for the server. No Aliases created.
local address: 192.168.1.123\RM - works from local computer ...
1
vote
1answer
683 views
“Classic” activity monitor in SQL Server Management Studio 2008?
Right now I'm using SQL Server Management Studio 2005 to manage all my SQL servers (2000, 2005, 2008). I'd love to be able to take advantage of all the cool new features in SSMS 2008, the only thing ...
