Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [visual-studio-2015]

31 questions
13
votes
3 answers

Option to uncheck all or invert selection in SSDT?

In SQL Server Data Tools (SSDT) after compared the schema, I want to update few changes of mine only (as red-circled in the screenshot). But there are many other changes are listed in the window, I need to manually uncheck all the other items. Is…
Arulkumar
  • 1,137
  • 9
  • 25
6
votes
1 answer

Failed to start TSQL debugger

I want to debug in TSQL.When I start the debug the following message box popup. In SSMS v17.2 Then I see this message: In Microsoft Visual Studio 2015 Server Explorer same Error: Then I see this message: Thank You!
József Kökény
  • 228
  • 2
  • 8
5
votes
1 answer

Visual Studio, GIT, and SQL Scripts

I am trying to figure out a way to have all of our random SQL scripts that we write under source control. I am already using SSDT for the database project. This is not for these sort of scripts. It is for all the other random queries that we run…
Anthony Genovese
  • 2,067
  • 3
  • 22
  • 34
4
votes
1 answer

Revision Tracking & Source Control for Azure SQL Data Warehouse

What is a good approaching for tracking incremental changes to database tables, stored procedures, etc for Azure SQL Data Warehouse? I am in the process of moving a large database over to Azure SQL Data Warehouse. The prior approach for change…
John Hargrove
  • 149
  • 1
4
votes
1 answer

What do most people use to work with SSIS packages since VS2015 UI is buggy?

I don't think I can post bugs on Microsoft connect. I'm trying to use SSDT on VS community edition. And the UI is terribly buggy. Here are some screenshots: The Enumerator properties manager is just painful. I can drag it down a tiny bit but can…
Zach Smith
  • 2,430
  • 13
  • 34
  • 65
4
votes
1 answer

"CREATE FILE encountered operating system error 32" when attempting to attach database

I am having trouble connecting to a database I created in SSMS. Keep in mind this is my first time working with databases. All I've done in this database is create some tables and add a few records. What I need to do is connect to this database in…
Lacuna
  • 61
  • 1
  • 4
3
votes
0 answers

User defined stored procedure - where's the execution plan?

SQL Server 2016, Enterprise Edition in Windows Is there anyway to display the execution plan of a stored procedure created in C# with Visual Studio Data Tools? This is a question that someone with Visual Studio experience probably knows the answer…
user4659
3
votes
2 answers

sqlpackage.exe SELECT statement causing massive reads

We are using sqlpackage.exe to deploy scripts onto a SQL Server 2016 SP1 instance. Running sqlpackage.exe executes this SELECT SELECT * FROM ( SELECT SCHEMA_NAME([o].[schema_id]) AS [SchemaName], [si].[object_id] AS [ColumnSourceId], [o].[name] AS…
user4659
2
votes
1 answer

How to remove Alter, Drop, Create SQL from deployment script created in VS 2015 using SSDT 14.06

I need to remove the below auto-generated deployment script for my SQL project. I am using VS 2015 with SSDT 14.06. Would this be something that can be set in the Advanced Deployment settings under the Drop tab ? This is for an existing Database…
Jason
  • 69
  • 2
  • 9
2
votes
1 answer

Class not registered error in SSAS Data Source View

Has anyone come across Class Not Registered issue while opening Data Source Views in SSAS using Visual Studio 2015? There are similar posts not haven't found anything exactly the same. Error text: Class not registered (Exception from HRESULT:…
yang
  • 41
  • 1
  • 2
2
votes
0 answers

Visual studio 2015 closed when re-run SSIS pack

I recently installed visual studio 2015 and there is a really simple action that I can not make, When I rerun (Ctr+Shift+F5) SSIS package (re-run, not run), it causes visual studio to throw this error: I do not know if this is related, but the SSIS…
Refael
  • 239
  • 4
  • 7
2
votes
1 answer

Send emails based on query results

I have a request to send emails the first of every month for each department that hasn't submitted their hours. I have a query that generates a list of email addresses, the email subject, and the email body. However, in the Data Flow SSIS Toolbox…
DForck42
  • 3,068
  • 3
  • 38
  • 67
2
votes
1 answer

Query not working is it issue with VS 2015 Community ASP.Net Core WebAPI or SQL Server 2016

I am experiencing an issue, which is beyond my understanding in trying to figure out, I am not sure if it is some glitch with Visual Studio, or something wrong with my SQL Server DB. I originally thought I just broke my code in an WebAPI I was…
Edward
  • 123
  • 7
2
votes
0 answers

SSIS parameter crashes Visual Studio

I am experiencing a weird behavior with SSIS parameters. At the start of the SSIS package, I have a script task. In the Script Task Editor I select a package parameter as a read only variable. When I execute the package, Visual Studio crashes. Other…
Mike Henderson
  • 179
  • 1
  • 8
2
votes
1 answer

Programmatically get parameters required by DACPAC

Is there a way to find out what parameters a DACPAC requires? I know they are listed in an error message if you try to publish without parameters, but that takes too long - 10-15 seconds. Also, a database needs to be targeted to get the error…
Metaphor
  • 906
  • 1
  • 11
  • 30
1
2 3