SQL Server Management Studio is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server.

learn more… | top users | synonyms

3
votes
3answers
2k 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
3k 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 ...
8
votes
10answers
43k 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 ...
1
vote
1answer
1k 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 ...
8
votes
7answers
21k 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
3k 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 ...
0
votes
1answer
2k views

Unable to save view: “There is already an object named 'Quotes' in the database.” - Error 1222

I often get the aloof error message above, after trying change a view in SQL Managment Studio 2008. I right-click on a view, select 'design', make a change (or not), and click the Save button. It ...
0
votes
1answer
3k 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
0answers
13 views

SQL Activity monitor doesn't show information

i am using SQL Server 2014 Management studio, it seems there is some problem with my activity monitor when connecting to the local SQL server. I am not able to see any information in that [User SA]. I ...
2
votes
2answers
2k 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 ...
1
vote
3answers
427 views

attach / detach mssql 2008 sql server manager

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
votes
1answer
14 views

Use reporting service configuration to configure the database source name

So im upgrading to R2. When i get to the Reporting Services Authentication step i get the error: There are validation errors on this page. Click ok to close this dialog box. Review errors at the ...
1
vote
1answer
2k 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 ...
8
votes
5answers
10k 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 ...
1
vote
1answer
213 views

Sql Management Studio 2014 wont connect to clustered instance

I am experiencing an issue where my instance of SQL Server Management Studio 2014 will not connect to any of our production clustered SQL 2000 and 2005 instances. It will however connect to ...
0
votes
0answers
22 views

Logging ALL actions inside SSMS

Any time one of the following actions occur in SSMS, I would like it to be logged in a SQL table/file. I tried different stuff but nothing seems to be perfect. I might use some funny terminology, ...
1
vote
3answers
3k 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
1answer
87 views

SQL/SSMS read only user who can only view a single database

I'm currently using SQL Server 2005 which has a number of databases on for individiaul clients. I need to create a single read only login for each of my clients, however I cannot allow them to see ...
1
vote
1answer
23 views

SQL SSMS Window Dissappear

When I open SSMS, I choose windows authentication, but the window just goes away; it doesn't say I'm not allowed. I've accessed these db servers before, the exact same way, and it has worked. Now, ...
1
vote
1answer
5k 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
2k 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
3k 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
3answers
3k 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 ...
2
votes
2answers
5k 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 ...
0
votes
1answer
160 views

SQL Server Multiple Instances but showing the same databases

I am running SQL Server 2008 R2 Standard Edition and need to have multiple instances which I have installed. However, when I restore a database onto one instance, it is showing up on the other ...
5
votes
5answers
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 ...
0
votes
0answers
161 views

Linked Server in SSMS: role of “String Column Lengths” values

I'm using linked server in SQL Server Management Studio in order to connect to Mongo database through ODBC. I have hard time trying to get data from Mongo. Here is a query I try to make: Select * ...
0
votes
1answer
638 views

SSMS 2008 not remembering connection login credentials

When connecting to a server on SQL Server Management Studio 2008, I'm entering the Server Name, and using SQL Server Authentication, entering Login & Password, and ticking Remember password. ...
1
vote
1answer
441 views

Shut down operating system by killing task

I came across quite an odd error recently and was wondering if anyone has any insight into it. I can't find any reference to such a scenario on Google so here goes... The rough sequence of events is ...
3
votes
1answer
749 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 ...
-1
votes
1answer
198 views

Connect to SQL Server from different network (remote) [closed]

I am new to SQL server stuff and recently thought of creating a Database for my website. I would like to stop things like comments, blog post, stuff like that. But I am trying not to pay for SQL ...
0
votes
0answers
431 views

Cannot login to Reporting Services through SSMS and Reporting Services Configuration manager

I am trying to connect to reporting services through ssms. I am getting a following error: "A connection to the computer cannot be established. Access is denied" I have system administrator/system ...
2
votes
2answers
364 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 ...
0
votes
0answers
817 views

SQL Server keep crashing, cannot connect with SSMS, Agent not starting

System Windows Server 2003 x64 SQL Server 2005 x64 Problems: 1) Cannot connect via SSMS - Tried both sa account and domain account (that is in sysadmin group) - If I supplied the wrong password, ...
1
vote
1answer
54 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
2answers
1k views

SQL Server does not exist or access denied on a local machine

I have the following exception when trying to open a connection to the server since last week. [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. I'm using MSSQL ...
1
vote
1answer
40 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
1answer
102 views

In SSMS, editing a table, can column names be sorted alphabetically?

SSMS Sorts column names alphabetically in all its dialogs - when choosing columns for indexes, relationships, etc. However, when editing ("Designing") a table, the columns are listed in the order in ...
-1
votes
1answer
384 views

SQL Server Maintenance Plan Wizard

Using SQL Management Studio 2012, when I right-click on an existing Maintenance Plan, and select the "Maintenance Plan Wizard" option from the context menu, what launches is a wizard to create a new ...
2
votes
4answers
2k 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 ...
0
votes
2answers
24 views

Looking for SSMS 2008 Express Only

I downloaded SQL Server 2008 Express from here..... But it still did not install the SQL Server Management Studio that I need to connect to my databases.....see image below....looking for this. ...
0
votes
2answers
2k views

SQL Management Studio on Windows 7 64Bit

We're scratching our heads a bit here. We have SQL Server 2000 on our internal systems and I have a new machine. My old windows XP machine had Mgmt Studio (full version). I have tried to run the SQL ...
0
votes
1answer
11k 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 ...
0
votes
0answers
288 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 ...
1
vote
4answers
6k 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
1answer
291 views

SQL server management studio 2005: Still can't copy column headers(checked option to include it already)!

I already changed the option to include column headers(Tools->option->results to grid->include column headers). Yet if I copy paste a Table or SQL query grid data results into Excel, i don't export ...
0
votes
1answer
394 views

What happens if a stored procedure is run in SSMS and it crashes?

What happens if a stored procedure is run in sql server management studio (SSMS 2012 to 2005 server) and it crashes? I'm guessing the stored procedure continues to run? On the other hand I have read ...
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
2answers
834 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 ...
0
votes
1answer
581 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 ...