1
vote
1answer
29 views

Why does SSMS Restore Database to another database not copy the current state of the “From” database?

When copying a database by using the Restore Database functionality in SSMS, why is it not a copy of the current state of the Database? After performing the Restore From Database Bar to Database Foo, ...
0
votes
0answers
382 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 ...
1
vote
1answer
34 views

SQL: name without a login name

I have noticed that when I open SQL server enterprise manager and I navigate to the list of users under a specific DB, I found users with"Name" but some have no "Login Name" value. What does this ...
0
votes
0answers
174 views

SQL Server Cannot see tables in Object Browser where Login = db_owner

A colleague is trying access a particular SQL Server over a remote link. He can login to the server (via SSMS) with the SQL Server credentials I supplied, but although he can view tables/etc in the ...
0
votes
1answer
590 views

Can't connect to remote mssql server

I'm trying to connect to my remote mssql server for my GunZ private server, but for some reason i get the following error Cannot connect to 94.xx.xx.xx. ADDITIONAL INFORMATION: A connection was ...
0
votes
1answer
237 views

Sql Server Management Studio 2008 has suddenly become unresponsive

I'm getting a very strange error when I try to launch SSMS from my taskbar. It seems to open in normal speed, but responds to any input with just a beep. CPU usage is 0% in Task Manager, and there is ...
0
votes
1answer
301 views

windows 7 - sql server 2012 - Maintenanace Cleanup Task

My Team Foundation Server creates backups. I want to clear backups that are older than 5 days. Create Maintenanace Cleanup Task in Maintenance Plans of Management of Sql Server 2012. Point there ...
2
votes
1answer
395 views

SQL Server Debugging: “Unable to Step. Invalid operation”

I'm debugging a call to a Stored Procedure in SSMS (2012). Frequently, and various random points in the code, a dialog pops up: Microsoft SQL Server Management Studio: Unable to Step. Invalid ...
0
votes
1answer
34 views

Export SSMS database connections to a new version

I just installed SSMS 2012 and realized it didn't copy my database list (the one that appears on the 'Connect to Server' dialog). I have a ton of entries there, is there any way I can export them ...
0
votes
0answers
90 views

SQL Server Management Studio Express 2008 is unresponsive

I use SQL Server Management Studio Express 2008 to manage SQL Server Express 2008. It (Management Studio) was working until recently, but now on opening it just hangs indefinitely, with all the panes ...
0
votes
1answer
2k views

MSSQL 2008 is claiming the firewall is blocking ports even from local machine

I was just hoping to step through a couple queries to see how the temp tables are interacting and I'm getting this message. The windows firewall on this machine is currently blocking remote ...
0
votes
1answer
135 views

SQL Server 2008 R2 and copy-only default value in SQL Server Management Studio

We are using Tivoli Storage Manager for taking backups of the database but sometimes our consultants need to take separate backup copies of the database using Management Studio. If they forget to mark ...
0
votes
1answer
255 views

Option do not show schema names in SQL Server Management Studio

I love the fact that tree and list controls in Windows allows incremental searches. Just select a starting point, and type, and the control will select the best matching node for you. This works in ...
0
votes
1answer
456 views

how to Allow remote SQL connections from specific IP

i use ms sql 2005 server . guide me: how to Allow remote SQL connections from specific IP. Thank all
1
vote
1answer
116 views

Removed SQLServerAgent account What should I do ?

I have removed by accident SQLServerAgent account and now I cant get access to the database. Connecting from management studio throws me error 26 and system log shows: SQLServerAgent could not be ...
1
vote
2answers
7k views

SQL Server 2008 Express: How do you remove a Database Engine instance?

I tried upgrading SQL Server Express 2008 to SP1, but the Setup was very far from clear. I ended up with 2 database engines. I now want to install Management Studio Express, but it apparently means I ...
1
vote
1answer
324 views

SQL Server query result transfer time over VPN (WAN)

I have a mysterious phenomenon on a remote SQL Server 2005 which I manage and query using SQL Server Management Studio. I connect to the server through a VPN tunnel (provided by an ISP, about 8 MBit/s ...
1
vote
2answers
1k views

Can't connect to SQL Server in different domain using SSMS and Windows 7 Crendential Manager

I need to connect to a SQL Server 2008 instance in another Windows domain to manage it. We only use Windows Authentication. In Windows XP, I could use the "Manage Network Passwords" feature to store ...
0
votes
1answer
120 views

SQL Server Managment Studio: “Tasks->Generate Scripts” and “Script Database As”

I'm developing an application that connects to a SQL database which I am managing with SQL Management Studio. With each version of my app that I save in source control I want to also save a copy of ...
3
votes
1answer
285 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
418 views

Backup SqlServer to a FTP-folder

Is it possible to let SQL Server 2008 make a backup to a FTP-folder. I know it's possible to specify as the backup target in SSMS an UNC-path. But is there also the possibility to specify an ...
0
votes
1answer
2k views

Error: Package 'Microsoft SQL Management Studio Package' failed to load. In SQL Server Management Studio

I had installed SQL Server 2008 R2, the installation was succesful. But I can't open the Management Studio because this error is shown: Package 'Microsoft SQL Management Studio Package' failed to ...
1
vote
2answers
181 views

SQL Management Studio - Restore from device problem

When specifying the Backup location by trying to click the Add button the dialog hangs and does not recover. This happens on all of our SQL 2000/2005/2008 environments. Could it be due to them running ...
0
votes
2answers
734 views

Set a login with username/password for SQL Server 2008 Express

I would like to set a password and username for connecting to a server with SQL Management Studio 2008. I set up SQL Server 2008 Express on a customer's computer to host a DB used by an Access 2007 ...
2
votes
3answers
981 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 ...
0
votes
1answer
1k views

SQL Server Management Studio Agent Jobs List View

I've recently moved from using SQL 2000 Enterprise Manager to SQL 2008 R2 Management Studio. I am administering the SQL Agent Jobs of a remote SQL 2000 Server and need to find the Next Run details of ...
0
votes
1answer
255 views

Supertype question from a mega noob

I've tried a couple database creation tools (MS SQL Server, MySQL Workbench, etc.) and I cannot figure out how to create a super-type relation (complete, disjoint). Below is an example of how it looks ...
2
votes
1answer
427 views

Add shortcut SQL management studio 2008 to select top 1000 order by PK desc

when I right click a table I can select select top 1000 rows and edit top 200 rows I'd like to add an option select bottom 1000 rows I am pretty sure that I've seen it somewhere online how to do ...
1
vote
2answers
716 views

Database not visible in SQL Server Management Studio

A colleague was overwriting a test database with a production database by doing a restore in SSMS (SQL Server 2005). He realized he had set the restore path incorrectly and canceled the operation. ...
0
votes
1answer
335 views

No Reporting Server connect option in SQL Server Management Studio 2008 Express

I'm trying to connect to our SSRS reporting server, but in my local SSMS, the Connect drop-down on Object Explorer only lists Database Engine and SQL Server Compact. I only installed SSMS this week, ...
1
vote
3answers
591 views

Sql Server management studio 2005 cant connect to localhost using windows authentication

I am trying to localhost using windows authentication with SQL Server management studio and I am getting a message that "Login failed for user..." (Error 18456). I made sure that all the services are ...
0
votes
2answers
388 views

Only show databases to user in which he has db_owner rights

I have an SQL Server with several users and databases. The permissions are imho simple: user1 is db_owner of user1_db1 user2 is db_owner of user2_db1 user3 is db_owner of user3_db1 user3 is db_owner ...
2
votes
3answers
242 views

How can you schedule a database backup on SQL Server 2005?

Not really familiar with MS SQL Server, but I did figure out how to manually backup a database locally: In SQL Server 2005 ( SP2 ) using MS SQL Server Management Studio : I navigate to ...
2
votes
1answer
142 views

Why does SQL Server Management Studio generate two renames in a change script?

I have just created a change script using SSMS 2008 Express, for renaming two columns in a table. However, the change script contains four renames, using an intermediate temp name. Why is this? ...
0
votes
1answer
36 views

Cannot delete SQL Server project file?

I have a .ssmssqlproj file in a Sharepoint folder, but I cannot delete it. It says that some application may currently use it. That is not true, because I don't have SSMS open. How to delete this SQL ...
1
vote
2answers
5k views

export proper csv from SqlServer management studio query result

in SqlServer management studio, you can export query results to a csv file by right click -> "Save Results as" -> csv. However, the csv file does not contain column headers and does not escape any ...
0
votes
1answer
155 views

SQL Server: How to create local server group?

In SQL Server 2008 EE, how can I create a local server group? And also, what is the benefit of using local server groups?
4
votes
3answers
4k views

How do I restore a batch of transaction logs rather than one by one

I have a SQL Server database that backs up the transaction logs every 10 minutes, with an overnight full backup. Using SQL 2008 Management studio we seem to have to select each transaction log one ...
0
votes
2answers
507 views

How to export a MSSQL table in MSSQL studio express 2005?

is there any way to export a table to a file without any additional tools? I can't install anything on that server.
1
vote
1answer
171 views

Hourglass won't go away in SQL Server 2008 R2 Management Studio

... after I add a column to a table. I've just started using 2008 R2 Management Studio, but I have a few years experience with 2005 Management Studio. Also, I am connecting to a 2005 instance of a ...
1
vote
3answers
2k views

Error when trying to open SQL Maintenance Plan - SSMS 2008

If I open SSMS on my client machine, connect to our SQL server, and try and open a maintenance plan on there, I get this error: TITLE: Microsoft SQL Server Management Studio Could not ...
3
votes
1answer
7k views

unable to connect to sql server analysis services on windows vista

I just installed sql server 2008 developer edition on my windows vista machine. The installation was successful. Reporting service is working fine. But I am not getting any option to connect to ...
0
votes
2answers
4k views

Can't connect to local SQL Server

I'm banging my head against the wall here and can't get things figured out. Yesterday I uninstalled SQL Server 2008 Express and installed a full copy of SQL Server 2008 R2. Everything installed fine ...
1
vote
1answer
473 views

Don't see job schedule added by sp_add_jobschedule in SQL Mgmt UI

I'm running a script like below on a SQL Server box and, even though it finishes correctly, then when, on SQL Mgmt UI, I right click on that job's properties, go to Schedules, I cannot see the ...
0
votes
2answers
678 views

Does SQL Server Management Studio 2008 Activity Monitor work with SQL Server 2000?

I am trying to use SQL Server Management Studio 2008's Activity Monitor with an SQL Server 2000 instance to diagnose some query performance issues. I can connect SMSS 2008 to the db fine, and use it ...
0
votes
1answer
2k views

Can you make a SQL Server Maintenance Subplan run after a previous subplan completes

I have a maintenance plan to do backups and cleanup of old data. It has three subplans, each with their own schedule. Can I set the schedule of subtask 2 to be "after subtask 1 is complete"?
5
votes
9answers
24k views

Can't remotely connect through SQL Server Management Studio

I have setup a SQL Server 2008 Express instance on a dedicated Windows 2008 Server hosted by 1and1.com. I cannot connect remotely to the server through management studio. I have taken the following ...
0
votes
2answers
3k views

What ports does Management Studio use to connect to SQL Server (2005)

I have SQL Server 2005 operating on a remotely hosted server and wish to access it from my own machine using management studio The firewall on the remote server is allready setup to allow all traffic ...
4
votes
4answers
2k views

How do you configure a MS SQL Server to prevent exposing all database names and logins to any authenticated user?

I'm new to MS SQL and asking this question as a web developer with limited sysadmin experience who desires his service providers to use best practices. We have one database on a remote MS SQL server ...
1
vote
2answers
2k views

Some rows giving “String or binary data would be truncated” error when editing in Management Studio

When trying to add data to a newly created column using SQL Server Management Studio (edit rows), I am getting the following error: No row was updated. The data in row 1 was not committed. ...