The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
66 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 - ...
2
votes
2answers
77 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
0answers
1k 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 ...
3
votes
1answer
301 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 ...
1
vote
2answers
1k 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 ...
0
votes
1answer
292 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
3answers
997 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 ...
2
votes
4answers
793 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 ...
1
vote
1answer
55 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?
2
votes
4answers
1k 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
930 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 ...
0
votes
2answers
705 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 ...
6
votes
7answers
13k 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
4answers
3k 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 ...
1
vote
1answer
988 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 ...
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
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 ...
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 ...