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)

0
votes
1answer
48 views

Maintaining multiple build versions of asp .net / SQL Server applications

We have new versions of .net applications deployed every week for testing given in form of new build files. Can any one suggest how I can maintain many versions of the builds without having to keep ...
0
votes
1answer
34 views

Inner join and group by [closed]

So I've got two tables. Accounts has three columns: id, Account_ID, Account_Name Tickets also has three columns: id, Account_ID, Description I can use the following query to get the most ...
1
vote
2answers
91 views

T-SQL — Why do ALTER and UPDATE statement only run when separated into their own batch?

I have update and alter statements that are only running when they are put into they're own batch. Below is my shortened version. It'd probably be a good idea to skip the code and read my question ...
4
votes
1answer
187 views

SQL Server Management Studio 2014 Backup - Set Property Devices Error

I recently upgraded my local SQL Server to Version 2014, which also installed the SSMS 2014. When using SQL Server Management Studio 2014 to create a backup (both local and remote, Server Versions ...
2
votes
2answers
284 views

Query data before a commit transaction

My understanding is that, in a MS SQL Server Management Studio window, after doing a "begin transaction" and then making some changes like add data to a table , you can only query that table and those ...
0
votes
0answers
112 views

Moving results from an MS SQL query in Excel - line breaks in data

I select all the output from my query by clicking in the left upper corner in the MS SQL Server Management Studio results window. I right-click, then select "copy with headers." Then paste into ...
0
votes
0answers
113 views

Export a varbinary column to file system using existing authentication

I want to export a varbinary column to a file system. I can use BCP command to export data from a varbinary column, which requires username and password being sent along with BCP command. I can use ...
0
votes
1answer
76 views

Compatibility level when upgrading a SQL Server 2005 database to SQL Server 2012

I would like to move my databases which are currently running on SQL Server 2005 to SQL Server 2012, using the Copy Database Wizard in SQL Server Management Studio. Should I first set the database ...
0
votes
1answer
69 views

Registered Server list and groups disappeared from SQL Server 2012 Management Studio

I recently installed SQL Server 2012. Due to some issue, the databases services did not install successfully, but Management Studio did, which was OK to start with, as I usually access remote servers. ...
1
vote
0answers
88 views

Renaming a column with sp_rename hangs SQL Server 2012

I was attempting to remove a column from a table within SQL Server 2012 for one of our developers. As a precaution, before dropping the column, we rename them to make sure that everything continues ...
0
votes
0answers
388 views

Error: Package ‘Microsoft SQL Server Management Studio Package’ failed to load [closed]

I have SQL Server 2008 R2 64bit installed with SQL Server Management Studio (SSMS). I've been using SSMS for log time but recently when I try to open SSMS, I get the above error. I've tried all the ...
2
votes
1answer
27 views

SSMS and Unicode fonts in grid results

I wrote this simple update query: update foo set test ='褠ఓ�ᵂ뱗텬㰗' where id = 1 [test] is an nvarchar(16) column. It's going to contain an encrypted value. In SSMS (10.50) I've set the font for ...
1
vote
2answers
274 views

hide system databases sql server management studio

I have installed sql server express 2008 and also sql server management studio. I've successfully configured remote connectivity and created a database user and password. my problem is that in the ...
0
votes
1answer
73 views

Replicate MySQL INSERT to MSSQL table

I'm running into a challenge here trying to "sync" a MySQL table with a MSSQL table. My scenario involves my linux-based website submitting form data submissions to a MySQL database on that web ...
2
votes
0answers
83 views

Full-Text Index menu option not appearing in SQL Server Management Studio AND error when right clicking a table

I am using SQL Server Management Studio Version 11.0.3128.0 and SQL Server 2014 12.0.2361 Web Edition. I have successfully created a Full Text Catalog following these instructions: Cannot use a ...
5
votes
1answer
249 views

View designer strange join syntax

I have a data warehouse with a lot of views built in with the SSMS view designer. Viewing the syntax, the FROM clauses are unintelligible to me because the ON statements do not follow straight after ...
0
votes
3answers
45 views

Reset Key Names to Defaults?

I'm working with some tables/columns that were renamed at some point, but the names of the primary/foreign keys are still based on the previous names. In SSMS is there any (preferably automatic) way ...
2
votes
0answers
27 views

Replication stopped working, no errors

I have a TOP server (SQL Server 2012) with a merge replication to around 4 other servers. When I subscribe to the publication, everything is downloaded fine to the subscriber. The insert of one of ...
1
vote
1answer
44 views

Linked server in SQL Server 2005 using NT authentication impersonation

I am trying to Link a server using an NT authentication as the impersonated connection, but this connection will be static to a specific user instead of passing the currently logged-in user's ...
1
vote
1answer
37 views

Get trigger query using query analyzer

I have a server in which there is no SSMS installation, and only query analyzer is available. And all I need to do is find the trigger information (basically trying to find out what that trigger ...
3
votes
2answers
239 views

SQL Server Management Studio: how to parse stored procedure code and check if table columns exist?

I'm afraid that SSMS won't parse table columns within a stored procedure. When you click in Parse option SSMS says that parse is completed, even when a procedure is selecting a column that does ...
1
vote
2answers
76 views

Create SQL Script Repository [closed]

I need to get all my SQL scripts in some kind of script repository. I have searched the web but no luck so far. I thought of creating a repository in a SQL database, my problem so far is to properly ...
0
votes
2answers
225 views

SQL Server Express: difference between connecting to localhost and localhost\sqlexpress

I am new to SQL Server and am following some tutorials. I have not yet created any databases. In SQL Server 2012 Management Studio I click on "connect" -> "Database Engine". I noticed that, using the ...
0
votes
1answer
684 views

View permission to SQL Server logs on SSMS GUI

I would like to give a user see SQL Server logs from GUI, not through xp_readerrorlog. I was just wondering if this was possible? Thank you.
0
votes
0answers
48 views

How can I deploy a composite data tier application (DACPAC) from Managment Studio?

I have SQL Server Managment Studio 2014 installed and want to use it to Deploy a Data-tier application (dacpac) via the GUI. My database solution consists of two .dacpac files, where one package ...
0
votes
1answer
31 views

Only Filtered condition gets deleted from index after datatype change using SSMS

In SSMS if I create a filtered index we can see filtered condition in index properties. But if I change column type of a column involved in filtered index using SSMS , then after column type changes ...
1
vote
0answers
50 views

SQL Server Comparison

I am merging two different versions of a database. I want to add some specific fields from source database to destination, so I used Visual Studio to do that. It does the job quite well but only table ...
0
votes
1answer
50 views

Reducing size of datatype involved in index fails where as increasing size work

This question is related to my previous question Database events that will cause deletion of index For example if i create a table like CREATE TABLE dbo.Customers (ID INT IDENTITY(1,1) PRIMARY KEY ...
1
vote
1answer
121 views

Ctrl-F1 shortcut stopped working in SSMS 2014

I've had the Ctrl-F1 query shortcut bound to sp_whoisactive for years (this technique is described in How to assign CTRL+F1 to sp_whoisactive in ssms 2012?). A few days ago, it stopped working: if I ...
1
vote
2answers
58 views

Cancel Query in remote ssms from ssms in my pc [closed]

We connect to our customer's database server with vpn. Sometimes we manage Sql server to connect database server or to connect with ssms in our pc's. I executed a query with ssms in database server, ...
0
votes
0answers
456 views

how can I track down the source of “Internal connection fatal error”?

I'm working on a 6-700 line SQL script today. I'm running it from SSMS. Pointing at a SQL 11.0 db. About half the time I run it, I get: An error occurred while executing batch. Error message is: ...
0
votes
1answer
100 views

HTML column in a full text index?

Using sql server management studio, I want to create a full text index where a certain field is treated as html, tags should be ignored and umlaut-codes should be taken into account. How can I do ...
1
vote
1answer
100 views

Measuring DB time of application using SQL Server Profiler

I have an application residing on the same host as a SQL Server database. There is a scenario in which this application is slow and due to co-existence of IIS and SQL Server, I cannot get which one ...
-1
votes
1answer
102 views

SQL Server Agent 2012 Job Schedule Report [closed]

I am looking for a report that will display graphically what jobs are scheduled on the server and when. My goal is to very quickly be able to glance at it and find a time where a new job will not ...
0
votes
0answers
253 views

Linked Server in SSMS 2014 - Shared Memory Provider, error: 0 - The pipe has been ended

I'm trying to connect to Mongo database from Microsoft SQL Server Management Studio through Linked Servers using Mongo ODBC Driver. Right now I'm testing Easysoft ODBC Driver. I can connect to the ...
2
votes
2answers
226 views

Large queries are slower in SSMS

I have a large table, about 750M rows. I have an application using Entity Framework to load and parse data, a query that returns 2 million rows takes 4 seconds. The same exact query takes 8 seconds ...
1
vote
1answer
29 views

SMSS will start for one user, but not another?

We have a MS SQL Server 2012 and SMSS 2012 installed. The C:\ recently ran out of space due to a misconfiguration, and now we have 1 user who cannot start SMSS they receive the error: "Cannot find ...
0
votes
1answer
404 views

Missing Database Mail Configuration Wizard in SQL Server 2008 R2

I was able to verify that Database Mail is installed and running but when I expand the management folder there is no Database Mail Configuration Wizard.
1
vote
0answers
50 views

SSMS 2014 (and 2012) CTRL+TAB requires pressing enter

Sometime last week my CTRL+TAB behavior changed. I used to hit CTRL+TAB, release, then I would be in my previous document tab. Now I hit CTRL+TAB, release, and the nav window is still open requiring ...
0
votes
2answers
579 views

Sql Server Management Studio can't remember passwords [duplicate]

When I connect to a database using ssms, I also have a checkbox labelled "Remember password". However, ssms will not remember the password. The next time I connect to the same server, I have to write ...
0
votes
1answer
87 views

Databases can't “see” other databases

This is a bit of a newbie question I think, but all the answers I've found online are for other questions, so I ask here: We have a server that we set up on a virtual machine to handle the passing of ...
1
vote
1answer
185 views

How to match a version of SQL Server 2008?

It is needed to install a new instance of SQL to the existing Windows SQL Server 2008. I have no idea what was used to originally install the existing 4 instances. Is it R5 SP32? Thanks to MS ...
2
votes
1answer
378 views

MSSQL Mixed-Mode Users cant connect unless they are in the server sysadmin role

SQL Server 10.0.5520 (2008 std sp3) My goal is to enable data connections in SSMS or Visual Studio for windows users w/out them being sysadmins. Ideally this would be done through Active Directory ...
2
votes
1answer
76 views

SMSS 2014 Network Server browser is empty

I trying to setup a MSSQL 2014 environment and I installed SQL Server Management tools for a dedicated management computer to reach database server nodes easily without starting this resource-hungry ...
0
votes
1answer
4k views

SQL import data when both source and destination has data and identity column

I am using Import and export data option to import data from one database to another database. Both database have similar structure of tables. All the tables have primary key which is identity ...
1
vote
2answers
61 views

SQL logins access

I am trying to set up a set of SQL logins (one for each developer) on a server who can have access to a given set of databases, currently the setup is as follows: Login 1: db_owner of databases 1, 2, ...
2
votes
2answers
89 views

Specific user can't view database contents

I have a particular user, let's call it TheUser. This user is able to connect to my SQL Server instance and view a list of the databases. However, upon expanding a database to view tables, stored ...
0
votes
1answer
681 views

SSMS 2014 installation - “Invalid license data” when opening ASP.NET files

I have just installed SSMS 2014 Express on a brand new Windows Server 2012 (x64) so I connect to the SQL Server 2014 instance running on a different Windows Server 2012. This is working without issue ...
0
votes
1answer
714 views

Change code editor variable highlighting colour

Within the SSMS Code Editor (for SQL Server 2012) I have this code written within the editor, that has a Dark theme applied. When you click on a variable, SSMS highlights all the other occurrences of ...
10
votes
3answers
14k views

Can I install SQL Server Management Studio locally?

Can I install SQL Server Management Studio on my desktop to access a database on a SQL Server 2012 instance? If so, where can I find the installer? Google searches only return 'express' versions ...