Questions tagged [visual-studio-2019]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-1
votes
0answers
20 views

Where do i change the xml file - connection manager problem [closed]

This error is thrown by Connections collection when the specific connection element is not found. looking at the 5 packages which make up the solution: 4 of the 5 packages have this: ...
-2
votes
2answers
25 views

How to join two tables and rename the new table? [closed]

I want to join two tables in sql and want to connect it with my .net project where I used web forms. help is needed. thank you
0
votes
0answers
30 views

Have two versions of one object in ssdt sql server database project or have objects visible/not visible depending on configuration option selected

I have a database project with 3 tables. 2 of the tables are the same table, but one is configured as a temporal table and the other is not. The 3rd table in the project is the history table for the ...
0
votes
0answers
731 views

RDLC report not working after upgrading from Visual Studio 2008 to Visual Studio 2019 with SQL Server 2016

After RDLC report updated with Visual Studio 2019 is not working with SQL Server 2016: Microsoft.Reporting.WinForms.LocalProcessingException HResult=0x80131500 Message=An error occurred during ...
1
vote
0answers
190 views

Debugging T-Sql code using Visual Studio 2019. Error message: frame not in module

DBAs, Has anyone had success using Visual Studio 2019 for debugging T-SQL code, the way SSMS allows Step-into & Step-over? When I hit debug (Alt-F5), gives me this error, after making some ...
0
votes
1answer
20 views

What is causing BETWEEN to be replaced with <= and >=?

We have a Visual Studio solution for our SQL Server 2019 database, and it is stored in a git repo. One table has a couple of check constraints using the BETWEEN operator, like this. CONSTRAINT ...
1
vote
0answers
109 views

IntelliSense is not woking SQL Server 2017 [closed]

I am using SQL Server 2017 and I had already installed Visual Studio 2019 before installing SQL Server. Sometimes when I create the first table in a database it gives me IntelliSense for that first ...
0
votes
0answers
303 views

Where does master.dacpac come from in VS 2019?

We have some build tasks that run and for the life of me I can't figure out why the ms build tools isn't installing the master.dacpac file needed for the master and system dacpac files. Here's where ...
0
votes
0answers
274 views

SSIS not able to run package in SSMS

It's very simple package, running fine when executed via visual studio. From the report I get: Visual Studio 2019 Community SQL2019CTP3.1 In the connection manager I am using windows authentication. ...