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 (2)

4
votes
2answers
5k 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 ...
2
votes
0answers
78 views

How to display differential backup date in SSMS Object Explorer Details

SQL Server Management Studio exposes the Object Explorer Details (selectable from the View menu option) and its context menu that allows adding fields to the default display. Full and Transaction Log ...
1
vote
1answer
1k 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 ...
2
votes
2answers
65 views

How can I get a copy of the SQL generated by Management Studio?

If I save a table in Management Studio's Table Designer for example, I believe it runs DDL SQL in the background. Is it possible for me to grab this SQL so that I can save it to a file?
1
vote
1answer
789 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 ...
5
votes
1answer
158 views

Can We Perform an “Up-To-The-Minute Restore” After Taking Transaction Log Backups?

The Setup: Say we have a Database in Full Recovery Mode that does a nightly Database Backup, Transaction Log Backup, and Transaction Log Shrink. Now the Transaction Log grows so quickly during the ...
6
votes
2answers
5k views

Allowing Foreign Key to be Null

I'm trying to create a relationship between two tables where one column in TABLE A is the foreign key for a column in TABLE B. However, there is one row in TABLE B that is currently null in that ...
10
votes
4answers
7k views

SSMS Tools Pack Alternative [closed]

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
49 views

Trying to take a backup of a database, but drives are different than in file explorer

In SQL Server Management Studio for SQL Server 2008, I do the following: In the Object Explorer windows, right click on the database Choose Tasks -> Back Up... The Back Up Database windows appears. ...
0
votes
1answer
3k views

Could not start the SQL Server Agent (SQLEXPRESS) [duplicate]

Possible Duplicate: Sql Server agent can not start I could not start the SQL Server Agent (SQLEXPRESS) instance as it will give me this error: The request failed or the service did not ...
5
votes
4answers
7k 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. ...
4
votes
1answer
800 views

Executing TSQL script generated from SSMS in SQLCMD. Failing on quotes

I am attempting to deploy a database to a machine by executing a script generated by the "Generate Scripts" tool in SQL Server Management Studio. Here is the command I've issued: sqlcmd -S ...
1
vote
1answer
129 views

Upgrading to SSMS with SQL Web Edition turned off Code Outlining : How do I get it back?

I upgraded to SQL Server 2008 R2 Web from Express with Advanced Services recently and code outlining went away. How do I get my collapsible code back? Thanks
3
votes
1answer
426 views

SSMS login to different domain

Our production database is hosted by another company on their domain. I'm able to RDP into the box and login with the credentials they provided me but when I try to login from my local computer on my ...
4
votes
3answers
2k views

Can I get SSMS to show me the Actual query costs in the Execution plan pane?

I'm fixing performance issues on a multistatement stored procedure in SQL Server. I want to know which part(s) I should spend time on. I understand from How do I read Query Cost, and is it always a ...
2
votes
1answer
103 views

Question about new behavior of current connection combobox in SQL Server 2012

I have a question about the new behavior of the database selection combobox in SQL Server 2012 (Press Ctrl + U to move your focus to it). It seems that, unlike in SQL Server 2008 R2, clicking in the ...
3
votes
1answer
165 views

Reset the numbering at the tabs of the Microsoft SQL Server Management Studio

I notice there are some numbering on the tab of each new query (such as the number 52, 56, 57 and 58 as shown in the following pictures) What does these numbers means and is it possible to reset to ...
5
votes
3answers
14k 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, ...
0
votes
0answers
170 views

Connect only once for all queries in SSMS?

I have an MSSQL database on a remote server. SSMS 2012 asks me to connect every time I double click a query in "Solution Explorer" in my project despite all of them having the same connection. Also, ...
1
vote
1answer
255 views

Database created in sqlcmd but missing in SQL Server Management Studio [closed]

I created a database named testbase in sqlcmd in SERVER\MSSQLSERVER. However, I cannot access SERVER\MSSQLSERVER. I also could not find testbase inside the server connection using Microsoft SQL ...
2
votes
1answer
177 views

SSMS Object Explorer Details causes deadlock while job is running

I have a problem with one of my SQL Server jobs. I've found that while the job is running, SQL Server Management Studio locks up. It always locks up while I'm looking at tables and sprocs within the ...
2
votes
2answers
225 views

How can I test sql scripts intended to run with sqlcmd -v in Sql Server Management Studio

From msdn I learn, that the Variable Precedence of :Setvar X Y is higher, than that of sqlcmd -v X=Y. I want to write a script, that uses the variables supplied to sqlcmd with the -v option, but ...
3
votes
0answers
214 views

Login failure error log when querying Central Management Server group

I am querying a group under a Central Management Server, which results in the following being logged to the SQL Server Error Log. Error: 18456, Severity: 14, State: 38. Login failed for user ...
2
votes
2answers
2k views

How to connect once for all queries in SQL Server Management Studio?

SSMS asks me to connect for every query in my project. Is there a way to connect only once per connection for all of the queries using it in my project? The answers below (March 2014) don't answer ...
8
votes
3answers
5k views

Can I connect to a SQL Server 2000 instance from SQL Server Management Studio 2012?

I would like to update my development machine to SQL Server 2012 but I still manage some (very old) SQL Server 2000 machines. Wil my 2012 SSMS be able to connect to those SQL Server 2000 machines? ...
1
vote
1answer
373 views

Database is too large due to appended backup

My database MDF file is at around 600mb. LDF file is at 147MB. I seriously doubt that it should be anywhere near this. I suspect it's because the database has been backed up by my host with the ...
8
votes
1answer
506 views

Why is “Lookup” colored as a function reserved word in SQL Server?

In SSMS 2208, the identifier "Lookup" is colored hot pink as if it were a function (same color as, say, "Power" or "Convert"). Why? I cannot find it in the official list of reserved words. Searches ...
3
votes
2answers
3k views

Copying View in Management Studio

I want to copy a VIEW from one server to another. I could copy tables but I can't copy views. Is there a way to do so? Thanks
2
votes
4answers
820 views

SQl Server Password Change after installation

I have installed SQL Server 2005, but at the time of installation I forgot to change my password. Now I can access my database only in window authentication mode, and I want to access the database in ...
3
votes
1answer
1k views

Running queries with SQLCMD vs. Running queries with SSMS

I've noticed something which i'm not sure about. can it be that running queries directly with SSMS is much faster than running queries with SQLCMD? I've noticed that the results of queries that ran ...
9
votes
3answers
1k views

How to control the order of servers listed in the SSMS connection dialog?

My current project involves a lot of database shuffling as we upgrade from SQL 2008 -> 2012, re-task hardware, repeat. One minor annoyance is the connection dialog in SSMS re-shuffling the server ...
4
votes
1answer
2k views

SQL Server 2012 is putting [brackets] around Table and Column Names

Is there anyway to turn that off? I'm unable to find anything in options, and they're really a distraction.
3
votes
1answer
925 views

Data Collection reports fail because login is from an untrusted domain

I've set up a data warehouse and Data Collection according to BO. Reports are generated properly when running them in Management Studio running on the server but fail when they are run from Management ...
3
votes
1answer
2k views

Management Studio all buttons disabled

I get an odd problem in my SQL R2. Although I can attach a new db to my db instance, but all buttons on the tool menu panel are disabled. So I cannot execute any sql query statements. It is really ...
4
votes
3answers
5k views

SQL Server Management Studio Express 2012 “ONLY”

I have installed SQL Server Express(SSMS) 2012 with management tools. After a few months, the Management studio has stopped working. The error is: «« Evaluation period has expired. For more on how ...
2
votes
2answers
1k views

Remove Database from SQL Management Studio Database List

I'm working with MS SQL Express 2008 and Visual Studio 2010. If you are attached to a local MDF file how do you remove it from the Databases list without deleting the file? The reason is to purge the ...
3
votes
1answer
2k views

How to check connection string in SSMS2012?

I'm connected to database. I use db by Management Studio 2012 Express. Can I check connection string by click something in Management Studio?
8
votes
1answer
7k views

Suppress SQL Server Management Studio auto complete

Is there a way to temporarily suppress SQL Server Management Studio's auto-complete while typing a query? I don't want to disable auto-complete completely just say hold down some key while typing in a ...
4
votes
4answers
7k 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?
5
votes
2answers
341 views

Alternatives for SSMS solutions & projects?

According to the official SQL Server Documentation, the use of "Solutions, Projects, and Items" is deprecated. A conspicuous (though somewhat cryptic) warning banner at the top of the MSDN page ...
8
votes
10answers
7k views

Sql Server Management Studio slow opening new windows

After upgrading both sql server and management studio from 2008 to 2012, the management studio 2012 is very slow when new query windows and dialog boxes are opened. Even right click on tables is slow. ...
1
vote
1answer
117 views

How to make SSMS Properties Window coincide with object selected in Object Explorer

The Properties Window in SSMS seems lame to me. All it shows is the current connection properties. I would like to be able to click on an object in the Object Explorer (e.g. a table or a column) and ...
3
votes
1answer
62 views

Save SSMS tabs with timestamp on a daily basis?

Is there a way to automate SSMS to automatically save down all current open tabs into a folder with a timestamp? Whilst I'd like to save every single useful ad-hoc query ever written with a nice ...
0
votes
1answer
68 views

Second instance of query designer for a single table in SSMS (Express)?

Forgive me if this is the wrong exchange site for this question. It seems like the right one. I have been a fan of writing queries manually for a long time, but recently I've got into the habit of ...
2
votes
2answers
356 views

Can you edit the context menu options?

Is there a way (registry hack is acceptable) to remove options from the context menus in SSMS? Specifically I'd like to remove the delete option from the context menu when you right click on a ...
8
votes
1answer
3k views

How can I force SQL Server Management Studio to update metadata?

Metadata in SSMS isn't updating unless I shut it down and restart. I've tried disconnecting from the server and reconnecting while the SSMS session is active, but that isn't working. Steps to ...
1
vote
1answer
1k views

Simple Car Rental database

I am trying to learn SQL development using SQL Server 2008 R2 Database Management Studio. I was trying to model a car rental company, where clients can rent cars, and I have to know which client has ...
5
votes
2answers
189 views

Does Restore “From database” restore from the most recent backup of the database or the actual live database?

In SSMS 2005, I want to use the GUI to copy a database by restoring in to a new database. I was using the "From database" radio button for the source, but then the databases in the list disappeared ...
2
votes
2answers
805 views

How to assign CTRL+F1 to sp_whoisactive in ssms 2012?

When I go to Tools > Options > Environment > Keyboard. Type in Query.Sp_whoisactive Press shortcut keys: Ctrl+F1 Click Assign. When I press Ctrl+F1, It still calls Help.
7
votes
2answers
6k views

How to apply a theme to SQL Server Management Studio 2008?

Has anyone had any success with, for example, applying a 'dark' them to the Text Editor component of of SSMS 2008? There was an old trick for 2005 which is no longer operational and has not been ...