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
1answer
681 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
445 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
51 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
128 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 ...
1
vote
1answer
39 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
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 ...
1
vote
1answer
638 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 ...
1
vote
1answer
56 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?
1
vote
1answer
570 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
1answer
106 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
1answer
95 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 ...
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 ...
0
votes
1answer
277 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
541 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
22 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 ...
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
1answer
160 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
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
92 views

Dialogs appear on wrong monitor with SQL Server Management Studio 2008

I am running SSMS 2008 on Windows 7 with a dual monitor setup (one large, one small). SSMS is running on the secondary monitor, but everytime a dialog is opened, the dialog is placed on the primary ...
0
votes
1answer
212 views

Fresh Install of SQL Server 2008 doesn't install managment studio. Help!

Ok I am running Windows 7, 64 bit. I cleaned of SQL server 2005 completely off my system leaving only SQL Compact Edition. I went here ...
-1
votes
1answer
12 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 ...
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 ...
1
vote
0answers
192 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
47 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
0answers
47 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 ...
1
vote
0answers
95 views

How to create an SSIS package with a Script Component

I am using Microsoft Business Intelligence Development Studio (BIDS) to create an SSIS package. Take into account that is my first attempt with SSIS. I want to take data from a Source database ...
0
votes
0answers
20 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, ...
0
votes
0answers
134 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
0answers
18 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 ...
0
votes
0answers
322 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
746 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, ...
0
votes
0answers
254 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 ...