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)

2
votes
1answer
49 views

remove maintenance plan

I have the following error while trying to delete some old Miantenance plans on the MS-SQL server: Please help.
2
votes
2answers
2k views

The log in this backup set is too recent, but it's from before the last full backup!

I'm trying to restore a full database backup plus transaction logs to the most recent transaction log. I've set up transaction logs to ship out every 15 minutes. This setup was performed via the SMSS ...
2
votes
1answer
341 views

Registered Server window does not show Database Engine or Local Server Groups

I am running SQL Server Management Studio 2012 on a Windows 7 machine. After a failed attempt to import my registred servers from SSMS 2008, the icons for Database Engine and Local Server Groups are ...
2
votes
1answer
738 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 ...
2
votes
2answers
1k 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 ...
2
votes
1answer
5k 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 ...
2
votes
1answer
4k 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 ...
2
votes
1answer
998 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 ...
2
votes
2answers
5k 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
315 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 ...
2
votes
1answer
20 views

SSMS: Import from flat file (.csv)

In SQL Server Management Studio (SSMS) 2008 R2, I wish to import a not-quite-properly formatted CSV into a database table. I was trying to use the wizard at <database name>->Tasks->Import Data. ...
2
votes
1answer
39 views

Local SSMS client is not connecting one particular server

My SSMS is not connecting to one particular server say X except X it is connecting to all the other servers. Could not find the root cause for this problem do any one have idea here? Guy sitting next ...
2
votes
2answers
163 views

Get physical disk id and drive letters from management studio?

Can anyone tell me how I can go about getting the physical disk id and drive letters of the local server from within management studio? I know I can grab the drive letters with xp_fixed drives and ...
2
votes
1answer
200 views

When using DBCC INPUTBUFFER to find query associated with spid, is there a way to show variable values of that query?

I have been troubleshooting an issue within a database that has some serious blocking issues. I found the command DBCC INPUTBUFFER a while back that allows me to see the query run for that spid. I ...
2
votes
1answer
106 views

How to script a table? [duplicate]

When I right-click a table in Object Explorer and click "Script Table" I can get SSMS to script my table. Can I do that with T-SQL code? I'm after the "CREATE TABLE xx" code that SSMS generates, so ...
2
votes
1answer
112 views

Querying MySQL and SQL Server from same IDE

I am currently working with MySQL and SQL Server. For querying MySQL I use MySQL Workbench, for SQL Server I use SQL Server Management Studio. I am mixing up shortcuts all the time. For instance, ...
2
votes
1answer
198 views

Linking SQL Server tables to a PostgreSQL Server

I have a SQL Server 2005 instance and also a PostgreSQL 9.3 running on the same network, I would like to know if its possible to somehow create or have 'views' on a database within the PostgreSQL ...
2
votes
1answer
81 views

SSMS returns results immediately; ADO takes longer

I am running a query that returns ~250k results. It is basically SELECT * FROM my_schema.my_view (and the view is somewhat complex, and all table references in it are two-part) I am not passing any ...
2
votes
2answers
115 views

How do I add keyboard shortcuts in SSMS 2012 to run a specific query?

How do I add keyboard shortcuts in SSMS 2012 to select all the data from table? In SSMS 2008 we could assign a shortcut in the following way: ...
2
votes
1answer
186 views

my azure sql database is not connecting with SSMS 2014

The firewall contain my IP in valid list but I am still getting error in connection. I tried the command C:\Users\MianAsbat>SQLCMD -U username -P password -S and got the following response. I ...
2
votes
1answer
98 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 ...
2
votes
1answer
1k 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 ...
2
votes
1answer
566 views

IntelliSense alternative using SSMS 2012 in a contained database as a contained user?

According to this answer about contained database disadvantages: If you connect to a contained database as a contained user, SSMS will not fully support IntelliSense. You'll get basic ...
2
votes
1answer
113 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 ...
2
votes
0answers
34 views

Unable to use select top N shortcut on Azure SQL Database via SSMS

Yesterday morning I was able to query my Azure databases via SSMS and the Select Top N menu shortcut. That afternoon I received a couple of alerts that my web applications couldn't connect to the ...
2
votes
0answers
28 views

SQL Server - Debugging - How to show parametervalues as HEX

I am writing a script which sets Parameters in the Registry for SQL Server. The following works on some of my servers but not all. DECLARE @Parameters AS VARCHAR(MAX) SET @Parameters = '-T1118' ...
2
votes
1answer
244 views

SSMS 2016 CTP3.1 November Preview (v13.0.800.111) bug? properties error: missing column federated_service_account

Using SSMS 2016 CTP3.1 November Preview (v13.0.800.111) on my laptop, whenever I right click any database object (the database, a table, etc.) I get the below error. TITLE: Microsoft SQL Server ...
2
votes
2answers
81 views

assigning permissions for running sysmail_update_account_sp

I have a Microsoft SQLSERVER 2014. The mail system is configured via DBMail and there is one stored proc in main web app (having its own database) which executes msdb's sysmail_update_account_sp by ...
2
votes
0answers
46 views

Code required to make column not nullable

I have a table where I mistakenly allowed NULL values in a column: CREATE TABLE EXAMPLE ( EXAMPLE_ID INT IDENTITY(1, 1) NOT NULL, FOO_ID INT, CREATED_ON DATETIME DEFAULT ...
2
votes
0answers
102 views

Hiding server folders for specific user in SQL Server Management Studio [closed]

Is it possible to hide folders like Security/Server Objects/Replication/.. for a specific login? I have a user who now connects to the SQL Server and he can only see hes own database. This is fine but ...
2
votes
0answers
336 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 ...
2
votes
0answers
365 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 ...
2
votes
0answers
35 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 ...
2
votes
0answers
163 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 ...
2
votes
0answers
331 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 ...
2
votes
0answers
88 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 ...
2
votes
0answers
89 views

How to safely take an SQL job out of the schedule?

There is a table | jobID | status | startTime | endTime | and a job, that is scheduled to run every X seconds, it will take the first undone job ID, put it in stored proc and run it. Stored proc takes ...
2
votes
2answers
626 views

SQL Server 2008 R2 Database Diagram Error Code

I have sysadmin privileges on a SQL Server 2008 R2 server. I'm working with the development database and want to save a database diagram I created. When I try to save I get the following error ...
2
votes
0answers
84 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 ...
2
votes
1answer
217 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
1answer
1k views

Connection to local SQL Server 2012 can be established from SSMS 2008 but not from SSMS 2012

I have two local SQL Server instances running on my local machine. The first is SQL Server 2008 R2 Enterprise Edition (named MSSQLSERVER) and the 2nd is SQL Server 2012 Business Intelligence Edition. ...
1
vote
1answer
11k 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
1answer
567 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 ...
1
vote
3answers
5k views

How do I use SSMS to compare Database 1 Table 1 against Database 2 Table 1?

I have two database - Database1 and Database2. Both database contain a table that have similar structure as follows: ...
1
vote
3answers
121 views

Show data and disk use breakdown by table

I have a SQL Server 2008 R2 database being used by several deployed programs. Question: Is there an easy way to display how much space each table consumes, for all of the tables in the database, and ...
1
vote
1answer
95 views

How to change default security on SQL Server database so that everyone can use it?

I have a database hosted on my machine that I want co-workers to be able to access and edit through a program I created. My current connection string is: ...
1
vote
3answers
568 views

SSMS 2014 working with SQL Server 2005 instances

Is there any major complication that one could run into while using the latest (developer) version of SSMS with older SQL Server 2005 instances? Any way one could affect the data by using this ...
1
vote
3answers
149 views

Proper way to export database to other servers

I am using SSMS (I am a software developer, not a DBA) and in each application release I need to release the database with its tables (some with data some with scheme only). I tried doing 3 things ...
1
vote
2answers
912 views

Are there any reasons not enable SQLCMD-mode as default in SSMS?

I don't consider "just to ensure that sqlcmd-mode is not required by a script" a valid reason. Any things to think of before giving the order to enable this setting to my coworkers?
1
vote
3answers
982 views

Is it possible to install a MS SQL Express Studio, where the studio tool also is included?

I am facing the following problem: I want to have a Express (=free) version of MS SQL Server and there I want to be able to see the SQL Management Studio interface. I have found only installations ...