Stack Overflow
Stack Overflow

Questions tagged [ssms-2017]

Microsoft SQL Server Management Studio 2017 is a graphical tool for configuring, managing, and administering all components within Microsoft SQL Server. Use this tag specifically for questions related to Microsoft SQL Server Management Studio 2017.

188 questions
1
vote
1 answer

How to find equal, modified, and unique SQL objects from multiple servers/databases?

Problem Summary: We have a set of databases on multiple servers that "should" all have the same SQL objects. Over the years, our developers have added/modified objects in various databases such that they do not match anymore. I need to obtain a list…
Ryan
  • 129
  • 1
  • 3
  • 13
1
vote
1 answer

Restore a bak file which is more than 3 GB on a SQL Server 2017 Express edition getting error

I am trying to restore database whose size is around 3 GB to a SQL Server 2017 Express edition, but I keep getting this error: Msg 1827, Level 16, State 4, Line 11 CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database…
user6885473
  • 298
  • 1
  • 5
  • 20
1
vote
0 answers

Create / open a .ssmssln or .ssmssqlproj in Visual Studio Data Tools (2017)

Any way to add a template to Visual Studio 2017 to Create a .ssmssln or .ssmssqlproj that can also be opened in SSMS 2017?
Marzipan
  • 13
  • 4
1
vote
1 answer

SQL query: using data in a column as column names in another table?

I am struggling to get data from within a table that looks like this: to display horizontally, grouped by GroupID, then the start/process/stop times (in that order) to display on a single row like this: I have tried writing several SQL case…
Jimbo
  • 67
  • 9
1
vote
1 answer

Job for Export Data From SQL Server to Oracle

I want to create a job with a specific query to export some date from SQL Server to Oracle. How can I schedule this? Thank you!
Costin
  • 17
  • 4
1
vote
2 answers

I cannot find SQL Server browser

I have installed SQL SERVER 17. I'm trying to connect to a remote Database and I was not able to do so. After research, I found out that it requires the SQL Server Browser service to be started but I couldn't find the service in the SQL Server…
Tushar Rajdev
  • 29
  • 1
  • 1
  • 5
1
vote
0 answers

new user/login GUI missing in SSMS 2017

I'm new to azure and I've created a new SQL DB and I want to create a read-only user for my DB (so I can use it in my web app) but when I go to create a new login/user (right click security folder > select new login/user) I get a query tab instead…
zero
  • 2,999
  • 9
  • 42
  • 67
1
vote
2 answers

How do I pass values from a table to a stored procedure as parameters?

I'm struggling with something that looks very simple, and yet I'm not finding any solution: I have Table called Hotels, which the first column in it, is = [hotels_id] [int] I have stored procedure that depends on hotels_id value Now in the Stored…
yossi.laher
  • 13
  • 3
1
vote
1 answer

SSAS Tabular Development DAX versus SQL performance

I'm currently working on an existing Tabular Model that has about 1.5M rows. It is driven by SSMS DB views and deploys to SSAS. My question is which language processes better/faster? When adding measures I can either create SQL case statements in…
z33Will
  • 39
  • 1
  • 8
1
vote
1 answer

SQL Query Returning Unwanted Data Which was Filtered on Where Statement

I've got the following query: When I execute the query, I get a lot of results for ad.Branch, including 106804. If I remove BOR.SSN like and COB.SSN like, and just leave branch, it returns only 106804 records which is the desired result. So I…
Nahuatl_C137
  • 132
  • 1
  • 13
1
vote
2 answers

Couldn't connect to database when using Top Resource Consumers QueryStore Report

We recently upgraded our SQL server to 2016 and I turned on QueryStore to do the analysis that it provides. I'm encountering a problem where, even if the time period of the report is Last hour, it will generate a message that says "Couldn't connect…
Xiphoen
  • 33
  • 1
  • 6
1
vote
1 answer

How to make multiple select statements into a SQL VIEW and MODIFY DATA THROUGH A VIEW?

I have these multiple select statements that I would like to make a CREATE VIEW dbo.vw_customers_addresses_services_servicetanks Here's my SELECT STATEMENTS: SELECT * FROM Customers WHERE EXISTS (SELECT * FROM Addresses WHERE…
zberg007
  • 51
  • 2
  • 7
0
votes
3 answers

How to find the size of a column in the database?

Is there any command for sql server that I can run and see the size of columns in a table? I need to know which column is leaving a heavy table I've already tried to run some commands, but the only one I found was to see the total size of the table,…
João Víctor
  • 45
  • 5
0
votes
0 answers

How do I solve the problem of empty backup folder when I try to restore a db in ssms

So I have some back up files in .bak formats which have been placed in the backup folder..C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Backup. but when i try to restore dabatase using restore file and file groups and just restore…
oyelowo toyyib
  • 3
  • 1
0
votes
1 answer

How to Implement a Lookup Activity in ADF to Check Rows Added After the Last Trigger Run

I have an ADF pipeline that contains a scheduled trigger to run the pipeline every two minutes. The pipeline's input table is linked to an SQL database in SSMS, and it detects any DDL changes. The input table has several columns, including event,…
Mouadh NASRI
  • 1
1 2 3
…
12 13