Questions tagged [visual-studio-2019]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
0 answers
630 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 ...
ToC's user avatar
  • 565
1 vote
0 answers
195 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 ...
umair mehmood's user avatar
0 votes
1 answer
36 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 ...
SQLDoug's user avatar
  • 237
0 votes
0 answers
150 views

SSDT db-project compare throws "source schema drift detected" for members of sysadmin

We are using SSDT database projects where changes will be done in the dev-DB, then a compare is done between the devDB and the VS-DBproject and selected changes is updated into the VS-project. Lately (...
GHauan's user avatar
  • 603
0 votes
1 answer
541 views

How can I downgrade an SSIS project for use with VS 2017 standalone?

I inherited a project that was being built in VS 2019. After I finished building it and asked the requestor for clarification on how to handle a few scenarios I get a warning that the license for VS ...
RemonsterGrrr's user avatar
0 votes
0 answers
199 views

Visual Studio Data Tools (SSDT) schema comparison tool does not match database objects

I am using Visual Studio Pro 2019 (16.9.4) and SQL Server Data Tools (16.0.62103.10080) but this happens since the beginning of Visual Studio 2019. I use the Schema Comparison tool to compare ...
Alex's user avatar
  • 101
0 votes
0 answers
598 views

SSIS Dynamically Loop through SQL Tables

I have been fighting with an SSIS package for sometime now. I did successfully build a package that will extract data from a specific table by creating a date list from a script task, use a ...
Stockburn's user avatar
  • 419
0 votes
0 answers
550 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 ...
rdelgado-incinc's user avatar
0 votes
0 answers
523 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. ...
gotqn's user avatar
  • 4,016
-2 votes
2 answers
1k 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
Deshani Amarasinghe's user avatar