SQL Server Management Studio, a graphical front-end tool shipped with SQL Server for managing and querying databases. It also supports managing other bundled systems such as SSAS.

learn more… | top users | synonyms (1)

1
vote
0answers
69 views

SQL server taking too much time in opening properties in SSMS

I am using sql server express 2008 r2 SP2 from about 2 years. Now a days when i try to check properties of database using sql server management studio it takes too much time(25 to 30 seconds) to open ...
1
vote
2answers
606 views

How to script all permissions on a schema

SQL management studio allows to create scripts for all db objects, however I so far couldn't find a way to correctly script a schema or user. The permissions of a user on a schema are not included in ...
0
votes
1answer
329 views

Connecting to sql azure from ssms throw exception 'sys.configurations'

Connecting to Sql Server Azure from MSSQL Server MGMT Studio, following exception occures : Cannot connect to xxxxxxxxx.database.windows.net An exception occured while executing a Transact-SQL ...
0
votes
1answer
43 views

Warn about table recreation on table change

By default, if you try to change a table using the designer making any of the following changes, you get an error message: You change the Allow Nulls setting for a column. You reorder columns in the ...
3
votes
1answer
145 views

Is it possible to filter the list of databases in the Object Explorer of the SSMS?

I know how to filter the list of tables - using the filter icon. However, this icon is disabled when the Databases node is selected. Still, I am wondering whether it is possible.
1
vote
1answer
143 views

SSMS command to disconnect after query has finished

In SQL Server Management Studio, is there any way (for example a SQLCMD command or something) to get the SQL script window to automatically disconnect as soon as the query has finished executing?
1
vote
1answer
526 views

Cannot change the Delete Rule of a self referencing foreign-key-relationship to cascade delete

I have the following table [dbo].[myObj] ( [ID] [int] IDENTITY(1,1) NOT NULL, [fk_ParentID] [int] NULL ) and I have a relationship from fk_ParentID to ID. I want to change the Delete Rule ...
1
vote
1answer
644 views

Intellisense in SSMS 2012 not working for 2008 server

I did most of the solutions provided here. I know about enabling IntelliSense clearing the cache connecting to a server >= SQL Server 2008 using the latest SQL Server Service Pack and it works ...
3
votes
4answers
292 views

SQL Server Designers, Failed Saves, and Generated Scripts

I am a big fan of the simple diagramming tool that comes with SSMS, and use it frequently. When I save changes to the model, I have it configured to automatically generate the change scripts that go ...
1
vote
1answer
99 views

Why would a query in code be slower than a query in a SQL tool

When we face performance issues with out application, one of the first things we do is try to isolate if the problem is the code, the queries or the database itself. The most frustrating part of this ...
4
votes
3answers
612 views

How to find unused indexes?

I am working on a Data warehouse. I have tables with up to 200M records. Some of these tables have around 20+ indexes (I can't provide a reason why they have been created in the first place). This is ...
3
votes
1answer
585 views

SSMS 2012 is not showing the tables of the system databases

I have SQL Server Management Studio 2012 on my laptop connected to a SQL Server 2012. If I go in System Databases and then any of the 4 (master, model, msdb, tempdb) I don't have the Tables folder. ...
1
vote
2answers
594 views

How to make SSMS upper case keywords

I recently started using Management Studio 2012. When using MySQL Workbench, a handy feature was that I could stay all in lower case and any reserved word (like SELECT, INSERT) would convert to upper ...
1
vote
1answer
86 views

Non-clustered index with all columns for “select * from”?

I have a simple SELECT * FROM MyTable WHERE DataDate = '18-AUG-2013' query on a table that contains 340 columns and 3.4M rows. Running estimated Execution plan in SSMS (Ctrl-L) suggests I create a ...
2
votes
2answers
709 views

Greyed out menu options, broken activity monitor

I recently installed SP1 on my 2012 SQL Server. Ever since then SSMS has behaved a little weirdly when I connect from my pc rather than from the local server itself. I no longer see the green ...
1
vote
2answers
114 views

Connect to SQL Server 2012 running on Azure VM via local SSMS 2012

I have been testing VM on Azure. I have created a SQL VM running SQL 2012 on Windows 2012 and would like to connect to it via SSMS 2012 on my local instead of connecting via RDP through Azure Portal. ...
0
votes
1answer
350 views

How to disable SSMS table designer timeout?

How do i disable the Table Designer timeout in SQL Server Management Studio? Background This KB Article seems to indicate that if you stop overriding the Designer timeout: To resolve this ...
0
votes
2answers
465 views

Color syntax printing in SSMS 2012

It seems the SSMS of Sql server 2012 cannot print the SQL statements with syntax color anymore. Is it a bug? Does it have any workaround?
9
votes
3answers
9k views

Can I use SQL Server Management Studio 2012 on a 2008 server?

My school is using SQL Server 2008. Last time I used it I only installed (at home) SQL Server Management Studio 2008 part, and used VPN to connect to school's server. Now I want to install SQL Server ...
9
votes
3answers
4k views

SSMS Tools Pack Alternative

Are there any tools out there comparable to SSMS Tools Pack 2012? The licensing ($30 per machine, $100 for any number of machines... for 3 months) leaves a lot to be desired and I wasn't sure of what ...
1
vote
1answer
321 views

SQL Server Management Studio 2012 - horrible blue background [closed]

I've just installed SSMS 2012 and when I loaded it up I was presented with a nasty blue background - it looks so bad that I honestly thought something was broken, but apparently it's supposed to look ...
3
votes
2answers
725 views

Recent Queries in SQL Server 2005

I'm using a PHP web application to interact with a database and need to catch an erroneous query. It's dynamically generated SQL and I don't know 100% of the code nor did I write it so I need to see ...
1
vote
1answer
512 views

To run SQL Server Profiler or to use the SQL Server Agent's Jobs function in SSMS or …?

I have a problem here - I wish to keep track of all transaction executed on the SQL Server but was wondering how should I proceed. If I were to use the SQL Server Profiler and configure it to store ...
3
votes
2answers
275 views

SQL Server Configuration Manager changes effected via Central Management Server

When using Central Management Server (CMS), under Central Management Server Actions, SQL Server Configuration Manager (SSCM) is an option. When launched, the GUI reflects the information of the ...
2
votes
4answers
4k views

Could not find the Server Agent in SSMS

I am following the guide - http://www.sqlchicken.com/2009/07/how-to-create-a-server-side-trace-with-sql-profiler/ which is working until I reach Step 8 8. Now to schedule your newly created script. ...
0
votes
1answer
112 views

Connecting to an SQL Azure Database from SSMS - IP Restriction

I am trying to connect to a new SQL Azure Database via SQL Server Management Studio. The client box running SSMS is hosted on a production DB so we restrict access on 1433 to just a handful of IPs ...
4
votes
4answers
5k views

Copy Database option not found in SQL Server Management Studio 2008 R2

I am unable to see the Copy Database option in SQL Server Management Studio 2008 R2. Can anyone tell me whats going on please?
0
votes
2answers
737 views

How to make SQL Server Management Studio use latest version of SQL Server?

I'm upgrading my dev machine from Windows 7 to 8. While installing earlier versions of Visual Studio it installed SQL Server 2005. I then went to this site and downloaded and installed SQL Server ...
2
votes
2answers
917 views

SQL server windows authentication through network

I am using sql server 2008 r2.There are about 50 pc in my office connected in network by using LAN.In a sql server 2008 r2 express(installed in windows 8) i have created all users windows account with ...
3
votes
2answers
436 views

Copy database, problem with not existing principal

I'm trying to copy a database from a server to my laptop, using Management Studio. However, after about an hour of copying, I get the error Cannot find the principal 'MVGSQL01\itsac', because it ...
4
votes
3answers
7k views

"Could not find stored procedure' even though the stored procedure have been created in MS SQL Server Management Studio

I have created a table testtable inside the database testbase that have the following structure: product_no (int, not null) product_name (varchar(30), not null) price (money, null) expire_date (date, ...
2
votes
0answers
137 views

SSMS causing Event ID 4674: SeTakeOwnershipPrivilege

Somewhat of a strange one. Recently my user id's been showing up in a number of Audit Success records in the Security event log of one of our production database servers with the below content (or ...
4
votes
1answer
2k views

Linked server available to users without permissions

I have users seeing a linked server which they are not supposed to see. The linked server is defined so that only I will have access to it, but everybody can see and use it. I have created the ...
-1
votes
2answers
564 views

How database users see their objects in sql server

I have a large SQL Server 2008 database that has many tables, stored procedures, and functions. This database also has several users. How can I make it so that each user, after connecting to the ...
2
votes
1answer
197 views

How do I rebuild single full text catalog (or why is “rebuild” full text catalog option disabled)

In SSMS. I have Full Text Catalog defined. If I select "Full Text Catalogs" folder - there is an option "Rebuild All" and it is enabled. But if I select individual FTC - "Rebuild" option (in context ...
3
votes
2answers
2k views

Users cannot view tables in non-default schema in SSMS

I'm having an issue setting the VIEW DEFINITION permission appropriately at the schema level for one of my users. I've created the schema TestSchema and added some tables. The user currently has ...
1
vote
1answer
109 views

In Job Step > Properties, only see two tabs: Package and Configuration

I am trying to set a job step that executes a package to use the 32-bit runtime, as it uses the SQL 10 driver against a SQL 2000 database. The job is running on SQL Server 2012. I see all kinds of ...
4
votes
3answers
2k views

Formatting T-SQL in SSMS 2012

According to this Microsoft document: http://msdn.microsoft.com/en-us/library/ms174205.aspx I am supposed to be able to use ctrl+K then ctrl+D to format my SQL documents in SQL Server Management ...
1
vote
1answer
589 views

Databases list not showing up?

This morning when I logged into SQL Server Management Studio (v 10.0.16) I clicked on the databases node and saw all by db's (they are hosted remotely) as I have done for the last 3 years. This ...
6
votes
1answer
533 views

Newly discovered SQL Server Express has all databases inaccessible/offline

We have several remotes sites at my company and today one of the employees came to me and said their SQL reporting tool stopped working. Up until this point I did not even know this server or ...
4
votes
2answers
184 views

Is there a limit to how many credentials SSMS can remember?

Using SQL Server Management Studio that came with SQL Server 2008 R2, I make connections to the same server using a number of different sets of SQL Server Authentication credentials. On my development ...
4
votes
2answers
284 views

Import Data replaces NULL with 0

I am using sql server 2008 r2 express. I am getting some problems when i use import data feature to import data from one database to another. I am using SSMS to do it. While using the wizard i choose ...
16
votes
3answers
1k views

Is it OK to blindly add missing indexes?

I often use SSMS to test my slow stored procedures for missing indexes. Whenever I see a "Missing Index (Impact xxx)" my kneejerk reaction is to just create the new index. This results in a faster ...
2
votes
0answers
81 views

Why does GO affect my SELECT? [closed]

I am experiencing a very weird behaviour from the Management Studio GO. I am following the full-Text Search tutorial and I run the following query over adventure works SELECT ...
4
votes
1answer
174 views

Is it “legal” to CREATE and DROP #SomeTable more than once?

I've got my code sort of segregated as "coherent blocks" that I can insert into a longer "configuration script" over and over, and one of the patterns I'm using is this: CREATE TABLE #WidgetSetting ...
2
votes
1answer
51 views

Display query which SSMS executes from Interface/WYSIWYG edits

If I am to add a new column to a table in SQL Server Management Studio 2008 via the interface/WYSIWYG (as opposed to writing a SQL query) this will, behind the scenes, create a SQL query which it will ...
2
votes
1answer
674 views

Attaching a database in SSMS gives error

I am accessing SQL Server using SSMS, and a user with adequate permissions. When this user tries to attach a database by using SSMS (by right clicking on database node and then clicking on attach), ...
4
votes
2answers
571 views

Error while taking backup using SSMS

I am using SSMS. I have about 5 logins. For a particular login I have all server roles other than sysadmin. It is a sql login (not windows authentication). In user roles it has all permission for ...
1
vote
2answers
1k views

Auto-generate scripts to create tables, indexes, etc

In SSMS, we can right click a database/table/index/... and select the "Script As" option to generate a drop and create script. Is there a way to automate this script generation and drop the scripts ...
0
votes
1answer
3k views

Manually entering data using Management Studio

How can I enter data through the GUI interface rather than an insert command in SQL Server Management Studio 2012? I can't find it anywhere whereas there used to be an option in the previous versions. ...