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

1
vote
1answer
20 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
53 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
1answer
71 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 ...
0
votes
0answers
112 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 * ...
1
vote
1answer
243 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 ...
0
votes
0answers
17 views

Hide databases in SSMS

In SQL Server Management Studio (SSMS) Object Explorer, it shows all the databases of the connected server. But I have access permission for some of the databases. Is it possible to show only ...
-1
votes
1answer
140 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
54 views

SQL Server Management Studio Import Wizard

I am trying to import a small excel spreadsheet into SQL using the SQL Server Management Studio Import Wizard, which is running on the Windows server (2008 R2) itself. When clicking "Import Data" from ...
0
votes
0answers
252 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 ...
0
votes
0answers
604 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
44 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
1k 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
37 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
85 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
270 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 ...
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
0answers
234 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
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 ...
0
votes
1answer
2k 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 ...
3
votes
2answers
1k 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
261 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
319 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 ...
0
votes
1answer
479 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 ...
0
votes
1answer
144 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
0answers
188 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
0answers
46 views

ssms script wizard not working with modified tables

I'm looking for a way to get all triggers and constraint we modified in a script to migrate them to a different database or reapply to this one if necessary. I'm using SQLServer Management Studio ...
1
vote
1answer
991 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 ...
1
vote
0answers
43 views

What does this setting do when copying SSIS packages? “Duplicate package folder structure on destination for selected packages”

What does this setting do for copying SSIS packages? "Duplicate package folder structure on destination for selected packages." Is there any reason why I wouldn't want to duplicate the folder ...
3
votes
1answer
623 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
1answer
1k 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 ...
0
votes
1answer
21 views

SSMS doesn't show all installed Instances

I've installed two named instances (SQLEXPRESS & MSSQLSERVER) but in SMSS, it only shows SQLEXPRESS when I try to connect. How can I connect to MSSQLSERVER from SMSS. Note. SQLEXPRESS was ...
2
votes
2answers
85 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 ...
0
votes
1answer
1k 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
40 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 ...
3
votes
1answer
794 views

Is SQL Management Studio 2012 avaliable, without Engine itself?

On my dev machine, I have SQL Management Studio 2008 R2 installed. I tried to upgrade to SSMS 2012 Express, setup finished but nothing happened. Is it possible to get SQL Management Studio 2012 ...
1
vote
1answer
117 views

Why does SQL Server Management Studio fail to connect on the first attempt?

When accessing SQL server on a remote development PC via Management Studio the connection will consistently fail on the first attempt. After the failure I retry and can now successfully connect to the ...
0
votes
1answer
86 views

How to restoring the Registered Server window in SQL Server Management Studio

Is there some way to restore the Registered Server window in SSMS ? I don't mean restoring the individual server details, rather I mean the actual window I've tried clicking the menu item "View \ ...
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
1answer
180 views

SQL Server 2008 Management Studio Express: won't recognize local instance

I’m having a lot of trouble getting Management Studio Express 2008 to recognize my local instance of SQL Server 2008 (SQLEXPRESS). Background: I’ve installed SQL Server 2008 x64 a few times today; 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 ...
2
votes
1answer
428 views

Viewing history for Maintenance Plan causing out of memory exception

I am trying to view history for a maintenance plan but keep getting an out of memory exception. It seems that the problem is that SSMS can't access memory beyond the ~3gb range. I've tried to find an ...
1
vote
1answer
602 views

Remote connection to SQL Server 2008 in LAN

I try many ways, but still doesn't work. MSSQLSERVER is running. SQL Agent is running. SQL Browser is running. TCP/IP is enabled (something else inside it must I change?) Named Pipes is enabled ...
2
votes
2answers
735 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 ...
0
votes
1answer
153 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
5k views

SQL Server 2012 - where is Management Studio?

I recently downloaded and installed the RC0 of SQL Server 2012. I followed the installation process as usual, however - I can't seem to find SQL Server Management Studio (ssms.exe). Where can it be ...
1
vote
1answer
439 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
742 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
votes
2answers
3k views

SQL Server: How to edit a view without scripting it?

How can i edit the definition of a view without having to "script" it in SSMS? The previous easy-to-use tools from Microsoft let me: Enter wait a moment Make change Carefully move mouse to large OK ...
2
votes
2answers
316 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 ...