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)

1
vote
1answer
17 views

append 0 returned by DATENAME function Sql Server management studio

I want to append 0 to my minute(mi) result returned by DATENAME function of sql server management studio. select datename(mi,GETDATE()) If the current time where 12:06:33.12(hh:mi:ss) then '6' ...
1
vote
1answer
49 views

Can we move SQL Server installed bit from default location to other drive

My client gave me command line installer for SQL Server. Since it is command line there is no option to select the installation path! So installer automatically chooses the default location C:\Program ...
1
vote
1answer
36 views

How do I compare all tables with nonzero rowcounts (in an archive db) with tables of the same name in the line of business db?

(Full Disclosure: I am a software tester who is out of my depth. Because I am unable to get a definitive answer from the developer due to the necessary independence of the test team, I have to figure ...
1
vote
1answer
873 views

How to do a SELECT inside of a PIVOT [duplicate]

I am trying to SELECT values from a column in my database in order to perform a PIVOT on those values without hard-coding them. SELECT * FROM (SELECT ItemType, [Status] FROM [EVAULTTEST].[dbo]....
1
vote
1answer
81 views

SQL Server 2008 R2 copy Schema with all user security permissions

I have a prod support request from a high value user to adjust the settings on a company-wide dashboard so that he can manage a section of his workflow currently being excluded from these reports. ...
1
vote
1answer
110 views

SSMS Database Node Refresh causes Restore to Fail

I have confirmed via testing that clicking on the refresh icon (one or more times) for the database node of a SQL Server instance being observed in SQL Server Management Studio (SSMS 2012) causes my ...
1
vote
1answer
964 views

Unable to ping/connect to azure sql server from sql server management studio

I created a database in azure and assigned a new server to it. I entered my ip address in the firewall and tried to connect to the server in Sql Server Management Studio but no success. I tried to ...
1
vote
2answers
4k views

SQL Server Express 2014 Installation directory

I face recently a problem when starting SQL Server Management Studio. As it can't start, I uninstall it. When trying to install it again, I am asked to select the installation folder of SQL Server. ...
1
vote
2answers
2k 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 ...
1
vote
2answers
211 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 ...
1
vote
2answers
1k 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 ...
1
vote
1answer
299 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
vote
1answer
48 views

SMSS will start for one user, but not another?

We have a 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 one ...
1
vote
1answer
2k views

Import errors importing CSV to SQL Server table

I am using SQL Server 2014 Management Studio to import a very large .CSV file into a table. So far I have been trying to accomplish this by right-clicking on the database and selecting Import Data, ...
1
vote
2answers
62 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, ...
1
vote
1answer
68 views

Warn about table recreation on table change

By default, if you try to change a table using the designer making any of the following changes, you get an error message: You change the Allow Nulls setting for a column. You reorder columns in the ...
1
vote
2answers
3k views

Intellisense in SSMS 2012 not working for 2008 server

I did most of the solutions provided here. I know about enabling IntelliSense clearing the cache connecting to a server >= SQL Server 2008 using the latest SQL Server Service Pack and it works ...
1
vote
1answer
539 views

Non-clustered index with all columns for “select * from”?

I have a simple SELECT * FROM MyTable WHERE DataDate = '18-AUG-2013' query on a table that contains 340 columns and 3.4M rows. Running estimated Execution plan in SSMS (Ctrl-L) suggests I create a ...
1
vote
2answers
1k views

Connect to SQL Server 2012 running on Azure VM via local SSMS 2012

I have been testing VM on Azure. I have created a SQL VM running SQL 2012 on Windows 2012 and would like to connect to it via SSMS 2012 on my local instead of connecting via RDP through Azure Portal. ...
1
vote
1answer
65 views

How to distinguish the current operation is done from system or from sql server management studio

We want to record who insert or update a table, so we add "CreatedBy" and "ModifiedBy" columns. When the data is changed through the application, we can easily get the person. But when someone uses ...
1
vote
2answers
4k views

Auto-generate scripts to create tables, indexes, etc

In SSMS, we can right click a database/table/index/... and select the "Script As" option to generate a drop and create script. Is there a way to automate this script generation and drop the scripts ...
1
vote
1answer
3k 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 ...
1
vote
2answers
42k views

Error: Specified cast is not valid. (SqlManagerUI)

I am trying to restore database created on server to my localbox however i am getting 'Error: Specified cast is not valid. (SqlManagerUI)' error message. Server Info: Windows Server 2008 Standard ...
1
vote
3answers
364 views

What is this error about in sql server?

Trying to restore database, getting a dialog in SQL Server Management Studio You cannot select backup sets from different databases" Any idea why I am getting this error? BTW backup is from ...
1
vote
2answers
6k views

Why are breakpoints not being hit in SQL Server Management Studio?

SQL Server Management Studio allows debugging of SQL (breakpoints and stepping through the SQL). It is possible to step in to a stored proc being called and to see a call stack. However I cannot ...
1
vote
3answers
58 views

How can I hide a column using a Select statement?

declare @bid varchar(4) = '1007' select sr.release_date, sr.customer_id, sr.customer_name, sr.item_id, sr.item_desc, sr.order_no, sr.qty_on_hand, sr.release_qty, ...
1
vote
1answer
57 views

SQL Server TempDB size issue

SQL Server reported that our tempdb is out of space. So I had a quick google search and found this on technet https://technet.microsoft.com/en-us/library/ms176029(v=sql.105).aspx Determining the ...
1
vote
1answer
22 views

Managing SQL Server logins and database users

I am getting a little further into the database administration side of things and starting to set up security access to SQL server databases for users. I have a question about server logins and ...
1
vote
2answers
54 views

Log in as another SQL Server user via SSMS to check their permissions?

I am getting a little further into the database administration side of things and starting to set up security access to SQL server databases for users. I have a question: Once I have given a set of ...
1
vote
1answer
30 views

Microsoft sql server management studio (SSMS) shortcut for changing size of sql/result panes

In the good old days there was a shortcut ctrl-B for changing the size of the Query & Result panes in the Query Analyzer sql editor. In Query Analyzer, just press ctrl-B and the screen splitter ...
1
vote
1answer
69 views

Hide Schemas and Tables

I have the following structure: Views dbo.vSales Sec.vSales Tables dbo.Security Sec.Products Sec.Countries Sec.Users I have 2 groups accessing my Database: Administrators Standard_User ...
1
vote
1answer
138 views

How to backup SQL Server database once evaluation period has expired

I'm using Microsoft SQL Server Management Studio from last one month that is evaluation period software. I'm not able to login in management studio. when I enter my user name and password it gives the ...
1
vote
1answer
86 views

SQL Server Management Studio: The columns in table do not match an existing primary key or unique constraint

I have two tables: Students and Courses. I want to set a foreign key in the Students table from the couseId column to the courseId column in the Courses table. I have set primary keys to both ...
1
vote
1answer
169 views

Maintenance Plan Wizard generates invalid script?

I've used the Maintenance Plan Wizard to create a plan. When I execute the plan, the "Maintenance Cleaup Task" fails with this error message: Executing the query "EXECUTE master.dbo.xp_delete_file ...
1
vote
1answer
115 views

Task generated T-SQL shows unknown property IsMemoryOptimized

I have modified a Maintenance plan on SQL Server 2008 using SSMS 2014, particularly Reorganize index task - I have added another two databases for this task. When I wanted to check if the T-SQL is OK,...
1
vote
2answers
564 views

Format column length in output - SSMS

SQL Server 2012. Sample query at bottom. I'm trying to create a simple report for when a given database was last backed up. When executing the query at bottom with output to text in SSMS, the ...
1
vote
1answer
29 views

restoring SQL Server from backup into a database with different database name?

I have been provided SQL Server backups to restore but they have to be restored into new databases with different names on same server. To explain it, say I have database "MyDB" and its backup "...
1
vote
1answer
3k views

How to change MSSQL Management Studio theme?

Different from: How to apply a theme to SQL Server Management Studio 2008? What I want is to change the theme not colour scheme of the editor. I want it to look as close as possible as Dark in 2015.
1
vote
1answer
69 views

Show the error message, after I accidentally clicked “Yes” on “don't show error again”

I was trying to alter an existing Maintenance Plan, but received an error on doing so. Before actually reading it I clicked it away, too late realizing that the text said "Do you wish to hide this ...
1
vote
1answer
460 views

Missing diagram option SSMS

I would like to create a relationship between to tables. Normally and in previous versions of sql server and the management studio I would go to database diagrams and draw the relation in the diagram. ...
1
vote
1answer
1k views

SQL Server Configuration Manager shows no services

I have installed Microsoft SQL Server Management Studio 2008 on my system. When I tried to open it for the first time, it asked me for the "Server Name" when I surfed I came to know that I have to ...
1
vote
1answer
52 views

When I implement database mirroring in SQL server it shows an error

When I click the start mirroring button it shows the below error message. When I try to connect the mirror and witness server through management studio it's connecting and working fine. The user I am ...
1
vote
1answer
28 views

Formatting SQL Source Code in SSMS [closed]

There are several source code formatters for SQL in SSMS. I have tried a couple and found that are not configurable in terms of what formatting they do (e.g. indenting). Does anyone know of one ...
1
vote
1answer
352 views

DELETE statement execution cancellation in SSMS

I ran a delete statement with wrong WHERE condition (which deletes all records from table instead of just 10 records) but during execution I found it and CANCELLED the execution in Management Studio, ...
1
vote
1answer
276 views

Can I import a specific vssettings file when launching SSMS?

In the interest of disambiguating between when I am connecting to non-production and production, I utilize vssettings for a specific theme in Management Studio (fire-and-brimstone style when in prod, ...
1
vote
1answer
63 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
89 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 does)....
1
vote
1answer
648 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
1answer
302 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 that?...
1
vote
1answer
595 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 ...