The tag has no wiki summary.

learn more… | top users | synonyms (1)

6
votes
5answers
6k views

How can I have SQL Server Management Studio 2008 connect to my instances automatically?

I'm running a server with 3 database instances. Right now, when I open Management Studio, it opens the "Connect" prompt that lets me choose which instance I want (or connect to anything else). Would ...
6
votes
2answers
306 views

SQL Server Management Studio Connect to Server List Editing

I'm using SQLServer Management Studio (2005) and I have a fairly lengthy list of servers in there, and I'd like to get rid of some of them that are no longer in use, without having to set them all up ...
5
votes
2answers
5k views

Using SQL Server 2008 Management studio to connect to SQL Server 2005 databases

I have a shared hosted SQL Server 2005 at an ISP, that I can connect to from SQL Server 2005 Management Studio. However, I cannot connect from SQL Server 2008 Management Studio. I log on with SQL ...
4
votes
2answers
218 views

Installing .NET 1.1 over later versions: Safe?

I have a server that is running all versions of .NET Framework, from 2.0 up to 4.0. An application I need to deploy won't run correctly on later versions, and was originally compiled for 1.1. Is it ...
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 ...
4
votes
9answers
23k 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 ...
4
votes
4answers
1k 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 ...
3
votes
7answers
7k views

SQLServer - need to access an ACT! database for data migration

I'm looking for a way to access data in an ACT! database for a data migration to a custom application. The ACT! software uses SQLServer 2005. The data conversion script and new application will be ...
3
votes
4answers
6k views

Timeout saving table in SQL Server

I'm trying to add a column to a table with much data in SQL Server 2005, using SSMS. So I browse to the table, select Modify, and add the new column. Then, when I press Save, I get the following ...
3
votes
1answer
259 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 ...
3
votes
1answer
6k 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 ...
3
votes
2answers
741 views

SQL Server Management Studio not scripting all objects

i've been attempting to script a database using SQL Server 2005 Management Studio. i cannot get it to script some objects. It scripts others, but skips some. i can provide detailed screen shots the ...
3
votes
2answers
1k views

How to connect to SQL Server via SQL Server Management Studio 2008?

I can't seem to get this to work. I have an IP address for a SQL Server. I have a login and password. How can I connect to it and work with it?
2
votes
3answers
6k views

SQL Server 2005: Copy SQL Server Agent Job?

I have a SQL Server Agent job comprised of 10 steps and each step has many parameters defined. Now I need another job almost exactly the same, but with a few differences. Since "copy / paste" isn't an ...
2
votes
3answers
236 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
140 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? ...
2
votes
3answers
915 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
3answers
143 views

Is it destructive to use SQL Server Management Studio to modify properties on an MSSQL 2000 database?

We have a few databases that are stuck in legacy mode at SQL Server 2000. I commonly use SQL Server Management Studio from SQL Server 2005 to query the data in these dbs from my desktop, but have ...
2
votes
2answers
610 views

Any known SQL Server 2008 Management Studio memory leak issues?

I'm not sure whether this question belongs here or to StackOverflow. I'm attempting here, since my question is in regards of memory leaks and management stuff more than programming. I have a SQL ...
2
votes
3answers
209 views

Backup MS SQL 2000 db from SQL Management Studio 2005 on another server?

The situation: I have an instance of MS SQL 2000 running on one server. On another server I've installed SQL Management Studio Express 2005. I can access the SQL 2000 server from Management Studio. I ...
2
votes
2answers
116 views

Can I use MSSQL2005 Management Studio to login to MSSQL2008 Express?

Can I use MSSQL2005 Management Studio to login to MSSQL2008 Express? Is that a must for me to install MSSQL 2008 Express?
2
votes
1answer
411 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 ...
2
votes
1answer
356 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 ...
2
votes
2answers
4k views

Change Windows Authentication user for Sql Server Management Studio

We're using Sql Server 2005 with Windows Authentication setup. So normally, when you log in using e.g. Sql Server Management Studio, it forces you to log in at MACHINE_NAME\Username. Anyways, on this ...
1
vote
3answers
8k views

Can I change a live SQL Database from Autogrow safely?

I have a live SQL 2005 database, and am in the very unfortunate position of being the involuntary DBA. The database has an MDF file that is 1.4 GB, and an LDF with 2.2 GB. The Autogrowth is set to ...
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. ...
1
vote
2answers
2k views

Why is SQL Server 2005 hanging up when I try to delete a database?

I've got a Windows 2003 server with SQL Server 2005 and when I log into the Management Studio, right-click on a Database and choose "Delete" I get the Delete Object dialogue. I then click OK at the ...
1
vote
2answers
620 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. ...
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 ...
1
vote
4answers
2k views

Trouble connecting to a remote instance of SQL Server 2008 (Developer Ed)

I just installed a named instance of SQL Server 2008 Developer Edition on our Windows 2008 server. I've been working all morning trying to enable remote connections but have been unsuccessful. Here ...
1
vote
2answers
1k views

Add conditions to maintenance plan sequence on SQL Server

I would like to add a condition to a sequence in my SQL Server 2008 Maintenance Plan. This condition is based on the variable set by a T-SQL Statement Task: declare @primary bit = 0 select @primary=1 ...
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
2answers
948 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 ...
1
vote
2answers
167 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 ...
1
vote
3answers
533 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 ...
1
vote
1answer
285 views

Why does SQL Server Management Studio sometimes lose my authentication information?

When I launch SQL Server Management Studio, most of the time it remembers the login & password, but from time to time, I have to retype the password. Is this something that happens periodically ...
1
vote
1answer
26 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, ...
1
vote
1answer
542 views

Is there a way of setting up a shortcut to a database for MS SQL Server Management Studio

I'd like to have a list of my database servers (I am a developer), I currently have a list of RDP files for different machines I connect to. Is there a similar feature in SQL Server Management Studio ...
1
vote
1answer
113 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
896 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 ...
1
vote
1answer
456 views

SQL Server 2008 Management Studio missing

I installed a named instance of SQL Server 2008 on the computer where there have been already some instances installed (they were installed without SQL Server Management Studio). During this last ...
1
vote
5answers
633 views

Error when trying to view properties in Management Studio

I am having trouble with sql manager after install SQL 2005 SP3, Can any shed any light on this one. Thanks TITLE: Microsoft SQL Server Management Studio Cannot show requested dialog. ...
1
vote
1answer
355 views

Trouble installing SQL Server Management Studio Express

Using VirtualBox I am running 64 bit versions of ... Windows Server 2008 R2 SQL Server 2008 R2 Express SharePoint Foundation I want to install SQL Server Management Studio Express, but I get this ...
1
vote
5answers
1k views

SQL Management Studio is painfully slow on 32-bit Windows 7

I've been having issues running anything in SQL Management Studio on Win 7. Basically, doing anything through the Management Studio interfaces completely freezes it up for a few minutes. Running a ...
1
vote
1answer
170 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
1answer
4k views

SQL Server 2005 Reporting Services - Configuration Manager & Management Studio Problems

When I open Reporting Services Configuration Manager on my server, an error message appears that says: Reporting Services Configuration Manager An unknown error has occurred in the WMI Provider. ...
1
vote
3answers
420 views

attach / detach mssql 2008 sql server manager [SOLVED]

An external consult wrote a guide on how to copy a database. Step two was detach the database using Sql Server Manager. After the detach the database was not visible in the SQL Server Manager... Not ...
1
vote
1answer
33 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 ...
1
vote
0answers
62 views

SQL Server 2005 on Windows 7 along with SQL Server 2008 R2 Express Edition

I've installed SQL Server 2008 R2 Express Edition in my Win 7 notebook. The Express Edition doesn't have SQL Profiler enabled. Thus it's hard for me to debug my SQL 2005 applications. I have a ...
1
vote
1answer
457 views

Missing menu items for Azure SQL tables within SQL Server Management Studio?

I have a table (say Table1) that is replicated via SQL Data Sync Agent across a local SQL Server 2012 as well as an Azure SQL Server (part of Microsoft Azure). Everything about Table1 (schema, table ...