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)

3
votes
1answer
221 views

Strange behaviours with SET options in SSMS

I am investigating the effect of various SET options on the creation of indexed views on SQL Server 2014 CU1. The following code: ensures that the SET options are as they should be creates a table ...
1
vote
1answer
439 views

Two SQL Server databases setup with same .mdf and .ldf files

In a SQL Server 2008 R2 instance two databases (the second one being a restore/copy of the first one) have been setup against the same .mdf and .ldf files. How would I go about either deleting the ...
0
votes
0answers
52 views

SQL Server Management Studio open disconnected

I am building SQL commands to deploy to an Oracle database. To see the proper color coding, I am using SQL Server Management Studio for SQL Server 2008 R2 to build and edit these .sql files. How can I ...
0
votes
1answer
226 views

SQLCMD mode: environment variable syntax?

I assume the best way to set my SSMS (SQL Server 2005) output file path during runtime of T-SQL, is to use SQLCMD mode. How do I use environment variables (e.g. %systemroot%) in the code? The ...
3
votes
0answers
80 views

Using Import Wizard with Access - No null values

I am trying to import a table from Access to SSMS using the Import Wizard but when I do the resulting table has a lot of empty strings instead of the NULL values that I am expecting. How do I make ...
-9
votes
1answer
43 views

TABLE CREATE IN SSMS [closed]

create table employee6(FullName varchar(50), DateOfBirth int,MobileNO int, HigherQualification varchar(50), ApplyingFor varchar(50),Regno int); insert into employee6 ...
2
votes
2answers
157 views

What does Reinitialize All Subscriptions actually do to the databases

I tried to find the answer and came across these MSDN pages but they don't actually explain what happens really: http://msdn.microsoft.com/en-us/library/ms152771.aspx ...
0
votes
1answer
508 views

Can connect to SQL Server 2012 via OSQL and SQLCMD but not via SSMS

We have individual developer edition SQL Server 2012 databases set up on each of our developers PC's. All PC's are Windows 7, firewall is disabled and everything runs fine. We're now looking to ...
1
vote
1answer
68 views

SSMS Intellisense - Data Dictionary Incorporation - Show Object Descriptions in Popup? [closed]

Can anyone point me in the right direction for an SSMS intellisense replacement that will show the object descriptions in the popup? This will help speed up onboarding as well as making myself ...
7
votes
7answers
1k views

How can I minimize the risk of accidentally modifying the wrong database?

I just learned the hard way that disconnecting from a server in the Object Explorer doesn't stop you afterwards from executing query windows that were already open on that server. My situation is ...
1
vote
0answers
1k views

Management Studio Generate Script Errors

I am trying to generate a script (right click database, tasks, generate scripts, tables) from SQL Server Management Studio 2008 R2 Express and I keep getting an error. I read somewhere that it could ...
1
vote
0answers
85 views

Change version number of maintenance plan package

We have a Maintenance Plan on SQL 2012 that has been running fine. I made a change to it yesterday using SSMS 2014. When the plan ran last night I got the following error: The version number in ...
0
votes
1answer
55 views

How can i insert the multiple data in table using the existance condition?

I am able to insert the multiple data in table mytest using the below query. But how can i modify the below query so that everytime it checks the first_name and @id_for_test and if its unique, it does ...
0
votes
1answer
200 views

Copy+Pasting currency value from SSMS 2012 to excel does not complete or calculate new value

So I'm trying to copy and paste some query results into Excel, and for some reason it seems to be not properly completing the first value. Let me explain what I mean by this. In Excel the cells I am ...
1
vote
2answers
3k views

Database cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery

I have received a database file and the instructions for loading it is to install SQL Server 2005 and then attach it using SQL Server Management Studio. After installing everything, I tried to attach ...
0
votes
1answer
3k views

A transport-level error has occurred when receiving results from the server. Semaphore timeout

I've searched around and I'll the questions seem to be old and none seem to resolve my issue. I'm running SQL Server 2012 Enterprise and experiencing the following issue: Msg 121, Level 20, State ...
1
vote
0answers
792 views

Cannot read property Collation.This property is not available on SQL Server 7.0. (Microsoft.SqlServer.Smo) [closed]

I am new to databases and Microsoft SQL. I just installed SSMS today and am getting this error while trying to add new login in security or rightclick-> view properties on user logins already there ...
3
votes
3answers
127 views

Get SSMS to show the time a query completed at?

I'm using Sql Server Management Studio 2012, and I'm wondering if there is a way to have a query show me at what time it was run and/or completed at. Basically just some kind of timestamp so that I ...
0
votes
1answer
298 views

Role-Schema Permission issue (Management studio)

When designing a new database I organized the table under different schemas. I've also created a new role that should have select/insert/update/delete rights on one schema and only select on another ...
3
votes
1answer
214 views

SHOWPLAN does not display a warning but “Include Execution Plan” does for the same query

I was running the following query in SSMS and it showed me a warning in the "Include Execution Plan" window select CLIENT_GUID, PMT_AMOUNT, DATE_COMPLETED from ( select payment.CLIENT_GUID, ...
1
vote
0answers
29 views

What does this icon in SQL Server mean? [duplicate]

Can someone tell me what the icon of a server and a blue database symbol means. It is attached to database engine instance in my object explore view. (I apologize, I am unable to add a image of the ...
3
votes
2answers
581 views

What does this SQL Server icon mean?

What does the icon of a server with a blue database symbol mean?
1
vote
1answer
32 views

cannot see logins subfolder [closed]

Forgive me for my lack of dba experience but I can't find the answer anywhere. I'm working remotely on a third party to a client that asked for a login, I created the login but there's problems with ...
2
votes
2answers
1k views

Reduce DB size - SQL Server, SSMS

One of my databases was growing in size a few gigs every day. That was very unusual since it is still in development phase. After small research i discovered that the Even Log table was almost the ...
1
vote
1answer
692 views

Management Studio won't recognize other file extensions

I am using SSMS 2012. I am working with .PRC, .TAB, and .UDF files. I added these file extensions to SSMS so that it would treat them like .SQL files already via Tools > Options > Text Editor > File ...
6
votes
1answer
925 views

Free space of mdf and ldf does not match with database free space

In SSMS I saw file size related properties and found below details for one database. Here values does not match with other properties. Here size of the mdf, ldf and total size matches with other ...
0
votes
0answers
17 views

Network flow for Import Export Wizard

When I use the Import Export Wizard on my workstation to move data from ServerA to ServerB does the data flow over the network directly from ServerA to ServerB? Or does it go from ServerA to my ...
0
votes
1answer
664 views

Error creating database in SQL Server Management Studio

I'm trying to create a new database in SSMS, but I get this error: Could not load file or assembly 'Microsoft.SqlServer.Sqm, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or ...
1
vote
1answer
95 views

Trigger to restrict users from creating a new table in the database

How do I create a SQL Server trigger that will restrict any users from creating a new table in the database? Please help me with this. Thanks & Regards, Ritesh.
1
vote
2answers
30 views

Multiple “model” DBs — or db creation 'profiles'

I know you can't actually have multiple 'model' DBs on the same server instance. BUT, I'd like to have something almost like it. Basically, we have a business model where each customer is its own DB, ...
2
votes
2answers
2k views

SQL Server 2012 Managment Studio not saving auto recovery files

I tried to go to Tools > Environment > AutoRecover. The check box of save autorecover is checked. Save every "5" minutes. Keep autorecover info for: 7 days. But it doesn't save any auto ...
5
votes
1answer
191 views

Capture Complex Actual Execution Plans

I have a stored procedure that among other things builds and executes a large number of Dynamic SQL statements. (Don't hate me, I didn't write it.) I would like to retrieve the actual execution plan ...
1
vote
0answers
563 views

SQL Server logs error

There are two SQL Server 2012 instances on the server. Named instance gives following error when Management > SQL Server Logs is clicked. Default instance works OK and opens Log file viewer. ...
3
votes
1answer
112 views

Suppressing the SSMS prompt to save changes

Is it possible to configure SQL Server Management Studio (SSMS). so that the dialog box shown above does not appear when I close an unsaved query window?
2
votes
2answers
406 views

General access denied error while using import data in SSMS

I am using SQL Server Management Studio with the following version information below: Microsoft SQL Server Management Studio 10.50.4000.0 Microsoft Data Access Components (MDAC) ...
1
vote
0answers
55 views

SQL Server 2008 upgrade and clean

After upgrading a SQL Server 2008 instance to SQL Server 2012 (in-place upgrade), there appears to be numerous 2008 instance components (namely the 2008 SSMS in start menu, in add/remove programs ...
4
votes
1answer
374 views

Database having only db_datareader shows invalid properties for a index

If a SQL server database user has only public permission in server roles and for a particular database only db_datareader and public permission then while trying script index as CREATE To option in ...
0
votes
0answers
60 views

SQL Server 2008R2 - Data Collection

I set up Data Collection for simple and basic monitoring of instances of SQL Server 2008 R2 (/2012) (is simple, accessible for and with very nice colors for my boss :-) But one of instances showing ...
5
votes
1answer
13k views

How to uninstall SQL Server Management Studio 2012? [closed]

How to uninstall SQL Server Management Studio 2012? ControlPanel's "Uninstall or change programs" (in Windows 7 Prof) gives a row of entries: while internet search results always tell: "click ...
0
votes
0answers
39 views

Copy SSIS 2012 Report Text to Clipboard?

When I run a SSIS 2012 report to view the errors, I note I can't select any text to copy to clipboard. Is there a way to get raw error text? (It seems you can right-click and export to ...
1
vote
1answer
2k views

How can I view special characters in SQL Server 2012 Management Studio grid view?

In a SQL Server 2012 database, I have a log table where I log SQL queries executed by a VB.NET application. The field is defined as nvarchar(MAX) In Microsoft SQL Server Management Studio, when I ...
1
vote
1answer
103 views

How do Identity Columns get Replicated?

During Transactional Replication, we have data going from Server A to Server B. Say we were to reseed an Identity Column on a Table on Server A (for whatever reason), how would this affect the data ...
0
votes
0answers
59 views

“Show table data” option to edit compact database

I have installed sql server compact edition 3.5 and i am sql server management studio to edit table.I am using "Show table data" option which comes on right click to a table of compact database. But i ...
0
votes
1answer
57 views

SSMS gives error if column name is “MERGE” where as other keywords works

IN SSMS create table if we include sql keywords in column name then it will be wrapped around square brackets "[]" automatically and the table gets created without any error generally. But if we ...
1
vote
1answer
166 views

What is the default value of ANSI Padding Enabled, and what should value should I set it to?

When creating a new database, ANSI Padding Enabled is set to False by default. According to this however, the default is ON (which I assume is the same as True). They also recommend to set it to ON ...
2
votes
1answer
48 views

Order results from query to have a certain result at the top

I'm not sure there is even a way to do this, but thought I would ask anyway. I have the following example output from a query: Name Country Number -------------------------- Harry Germany ...
1
vote
1answer
94 views

Configuring transactional replication with updatable subscription via SSMS 2012

Can I configure transactional replication with updatable subscription via SSMS 2012 (SQL Server 2012)? Is this removed from SSMS 2012 or I'm just missing something here?
1
vote
0answers
164 views

Alternative method of viewing a database diagram in SQL Server to see what tables have gone missing? [closed]

I have a database diagram for my database, but when I open it in SQL Server, I almost immediately get a message saying some permissions changed or tables in the diagram were dropped or renamed, and ...
1
vote
0answers
114 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 ...
2
votes
2answers
5k 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 ...