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
2answers
42 views

Quickly clone a database in SQL Server Management Studio

For testing purposes, I often have to clone databases (onto the same server). Currently I do this by creating a backup and restoring it as a new database. I would love to have such a functionality ...
0
votes
0answers
19 views

SSMS IntelliSense doesn't work on particular database

I have SSMS 2014 installed on my desktop, and many 2012 and 2014 databases running in our data center, so far I found one database (database A) doesn't have IntelliSense working, e.g. typing: SELECT ...
-1
votes
2answers
31 views

SQL Server Temp Database Monitor Tools [on hold]

Please suggest best tool to monitor temp db activity to find the objects which have excessive temp db usage.
0
votes
1answer
44 views

Update a set of SQL statements

dbo.MatchFirstName(@FirstName) and dbo.MatchLastName(@LastName) are table Value Functions(TVFs). Problem: In my Update statement i.e Update #Temp after Insert, I want only those rows to be ...
1
vote
2answers
27 views

SSMS (2012) limit # of characters on editor window line

Is there a way to enforce a hard limit on the number of characters allowed on a line in the SSMS editor window? I have searched, but am unable to find an option to set this. I'd like to force the ...
1
vote
0answers
23 views

SSMS login fail to Linked Server

i have one server with SQL server 2012 standard on cloud environment and one linked server with sql express on remote location connected with VPN , im using transactional replication every time when ...
0
votes
1answer
23 views

SSMS 2008 R2 no longer connects to database [closed]

Before Christmas I had no problem connecting SSMS 2008 R2 to a specific remote database. Since Christmas, I get this error when I try to connect: TITLE: Connect to Server Cannot connect to ...
0
votes
2answers
79 views

Can't restore database?

Im trying to restore, let's say, db1. But some of my colleagues are using db2. We're in the same sql server. Why can't I restore my db1.bak even if Im the only one who's using it...? I tried "Take ...
0
votes
0answers
35 views

Bring back the replaced database?

Story: I tried to restore my backup database using a different name (The backup database name is "db1" and db1 is still existing in sql server. In restore, I renamed the "To Database" field into ...
0
votes
1answer
23 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
29 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
56 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 ...
3
votes
0answers
47 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 ...
1
vote
2answers
54 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
31 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
32 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
40 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
40 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
47 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
56 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
18 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 ...
0
votes
2answers
56 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
29 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
42 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
244 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
24 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
34 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
19 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
108 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
65 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
84 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
189 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
30 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
30 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
49 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
36 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
55 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
49 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
185 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
50 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
62 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
64 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
155 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
208 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
28 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
239 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
32 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
258 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
86 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 ...