Stack Overflow
Stack Overflow

Questions tagged [ssms]

Microsoft SQL Server Management Studio is a graphical tool for configuring, managing, and administering all components within Microsoft SQL Server.

SQL Server Management Studio is a tool included with Microsoft SQL Server 2005 and later versions for accessing, configuring, managing, administering and developing all components within Microsoft SQL Server. The tool includes both script editors and graphical tools which work with objects and features of the server.

SSMS combines the features of Enterprise Manager, Query Analyzer, and Analysis Manager, included in previous releases of SQL Server, into a single environment. In addition, SSMS works with all components of SQL Server such as Reporting Services and Integration Services. Developers get a familiar experience, and database administrators get a single comprehensive utility that combines easy-to-use graphical tools with rich scripting capabilities.

On Wikipedia: SQL Server Management Studio

7484 questions
2
votes
1 answer

Using an aggregate for totals using Rollup

I am experimenting with using Rollup, and wanted to find out if there's a way to achieve this without using a subquery, CTE or Temp Table. Here's my code: select coalesce(Answer,case Grouping_ID(Answer) when 1 then 'Total' end) as Answer ,…
Corrie
  • 23
  • 2
2
votes
4 answers

SQL Server 2008 R2 First Time Login

I've just started work on a new computer in which I had to download all the software fresh. I've just download a copy of SQL Server 2008 R2, and I'm trying to connect to SQL Server Management Studio without success. I vaguely remember last time I…
109221793
  • 16,477
  • 38
  • 108
  • 160
2
votes
1 answer

Encrypt/Decrypt column in sql server using entity framework

I am trying to encrypt and decrypt some columns in SQL database using Entity Framework 6 and database project. I created my master key: CREATE COLUMN MASTER KEY [CMK_1] WITH ( KEY_STORE_PROVIDER_NAME = N'MSSQL_CERTIFICATE_STORE', KEY_PATH =…
Samy Sammour
  • 2,298
  • 2
  • 31
  • 66
2
votes
1 answer

How to get current user ID in SSMS from Visual Studio?

I have a program in Visual Studio that loads table data from SSMS. Right now, it's hard coded in to load specific tables no matter who logs in. In SSMS, I have tables of college classes. When a user logs in, I want to run code in Visual Studio to…
tryingtotryhard
  • 134
  • 10
2
votes
1 answer

TSql dbcc checkident command fails when database exists

Running the dbcc checkident command in SQL Server Management Studio, trying to reset the identity column. As you can see in the picture below clearly my table exists and the schema is the default dbo. But when attempt to execute: dbcc checkident…
Matt Phillips
  • 11,249
  • 10
  • 46
  • 71
2
votes
0 answers

Export SQL DB to a BACPAC using Export Data-Tier Application - Check Status

I am trying to export data around 30 GB from SQL server table in bacpac format ,using Export Data-Tier Application in SSMS 2017 version . It's still in progress since last 3 hours and at step "Exporting data from database". Is there any way where I…
StackUser
  • 21
  • 4
2
votes
1 answer

Loading .mdf/.mdv file into SQL Server Management Studio

I downloaded SQL Server Management Studio to my laptop at home. I don't have a database as it is my personal PC. Is it possible to connect to a .mdf file and do SQL querying in that ?
ashwath raj
  • 33
  • 5
2
votes
3 answers

SQL SERVER backup database into .sql file using script or cmd

I am trying to migrate from SQL SERVER 2012 to 2014 and found out I cannot use .bak files because of different versions. I know how to create a .sql back up file using the SSMS but I can't find a solution using a script or sqlcmd.
Dekso
  • 541
  • 4
  • 23
2
votes
2 answers

Copy all columns without data but with dependencies in SQL

So i'm trying to copy all data of table CarOrders into a new table, NewCarOrders. But i only want to copy columns and dependencies and not data. I don't know if it truly matters, but i'm using SQL Server Management Studio. Here are two things that i…
Billy
  • 183
  • 2
  • 14
2
votes
1 answer

Convert int in string to integers in T-SQL

I need to convert string to integers, but I'm getting a type error. declare @stringinteger nvarchar(255) null; set @stringinteger='1,2,3,4' select * from user where id in (@stringinteger) The error I get: Conversion failed when converting the…
Murat Can OĞUZHAN
  • 735
  • 11
  • 19
2
votes
1 answer

LocalDB connections visible in SQL management studio

In my unit tests, I'm using a SQL Server LocalDB database. You could be nit picky and say that because of that fact it's not unit tests but integration tests and you would be right, but the point is that I am using the MSTest Framework to run those…
nvoigt
  • 75,013
  • 26
  • 93
  • 142
2
votes
2 answers

Trying to figure out how the best way to use TSQL to retrieve current date but have a time value hard coded for select queries

Currently I am looking for a way to avoid hard coding date values for select queries I seek to automate. Ideally my queries will run daily on a report server, so I want the day to change automatically but I would like to specify the time values the…
Thomas
  • 105
  • 1
  • 6
2
votes
2 answers

saveDelimitedColumns

I am using the stored procedure, saveDelimitedColumns (found: http://www.virtualobjectives.com.au/sqlserver/saving_), to save data results as a .csv file. This works great with one exception...when it saves as a .csv file the column headers within…
georgia912
  • 23
  • 2
2
votes
1 answer

SQL Server Management Studio, no New Project option

I used to organize my queries in a Projects/Solutions in Management Studio at work. But after I had installed SSMS at home I coulnd't find and option to create new project. In File-> New there is only New Query, and Policy but no Project/Solution. I…
Granton Smith
  • 31
  • 3
2
votes
2 answers

I'd like to reuse a condition in a big SQL query, is that possible?

For example I need to reuse a condition like this: e.exampleTableDate between '2018-01-01' and '2018-01-10' In multiple places in the text. Is it possible to put this query in some kind of a placeholder in the beginning and change just that to…
cybera
  • 351
  • 2
  • 17
1 2 3
…
99 100