16 votes
Accepted

What is the best way to include SQL Server Agent jobs in Source Control?

I'm really glad you asked this question. I had this very same need for SQL Server jobs in a Visual Studio database project and job deployments along with a database. I wanted the solution file ...
user avatar
13 votes
Accepted

"Invalid object name" error when executing query

I'd guess the problem is your SQL Server login does not have it's "default database" properly set. This will show you what your "default database" is set to: SELECT sp.name , sp....
user avatar
  • 67.2k
13 votes
Accepted

SSDT Drop and Recreate Tables when nothing has changed

After a fair amount of frustration, finally found the cause, and posting as an answer as it may help others.... Finding the reason for why SSDT thought the scheme was different I think is the first ...
user avatar
  • 321
8 votes
Accepted

Regenerating a cube relational schema in Visual Studio

That's not how it works. A .dsv (data source view) is generated by defining which tables/queries you want to use in your cube. The flow is: create one or more .ds data sources by defining how to ...
user avatar
  • 15.4k
8 votes
Accepted

How to change "deployment target version" on SSIS 2019?

Be sure to go to the Project properties, not the solution properties. See image below.
user avatar
  • 1,244
7 votes
Accepted

Error starting localDb on Windows 11

Windows 11 and Windows Server 2022 do not report compatible PhysicalBytesPerSectorForAtomicity information for some SSD storage devices at this time. This causes issues with SQL Server IO when ...
user avatar
  • 24.3k
6 votes
Accepted

SSDT on VS2013 for SQL Server 2012

That is correct. Forward compatibility is guaranteed. Backwards compatibility does not exist*. Having 4 different BIDS/SSDT instances on a machine is a pain I've known all too well but there's not ...
user avatar
  • 15.5k
6 votes
Accepted

visual studio 2017 vs sql management studio

Although Management Studio is based-upon Visual Studio, the two are different products and have different target audiences. You will not be able to use Visual Studio to do all of the tasks that you ...
user avatar
5 votes

visual studio database project - publish did not include drops but schema compare did

Publish>Advanced Settings>Drop>"Drop objects in target but not in source" https://stackoverflow.com/questions/1799802/dropping-a-table-with-visual-studio-2010-database-project
user avatar
  • 171
5 votes
Accepted

What does @RC mean in SSDT SQL Server Unit Testing?

@RC = Return code. The boilerplate unit test code will assign the stored procedure return code value to this variable, where it can later be used in a test case assertion. Assuming there's a ...
user avatar
  • 24.3k
4 votes

SQL Server Data Tools for VS 2015 - Anyone using for SSIS development to multiple versions?

Visual studio 2015 SSDT work with SQL Server 2016 and has a backward compatibility to SQL server 2014 and 2012 only. Target version of SQL Server | Development environment for SSIS packages 2016 ...
user avatar
  • 1,212
4 votes

What is the best way to include SQL Server Agent jobs in Source Control?

I think the best option is to include the create job statement in a post-deployment script. Like the solution in this thread: How to deploy a SQL Server Agent Job in a VS SQL project?
user avatar
4 votes

Regenerating a cube relational schema in Visual Studio

The only time you need to use Schema Generation is if you did top down development and have never generated the schema before. Now that you have previously generated the SQL schema, you can just ...
user avatar
  • 1,365
4 votes
Accepted

SSIS : Null value for date keeps failing

Unfortunately, SSIS variables can't hold NULL values. NULL is allowed in data flow's columns but not on variables, this is a limitation of the underlying COM objects used by SSIS. You will have to ...
user avatar
  • 3,239
4 votes
Accepted

Publishing database changes with SSDT that include adding columns to existing table to the target database through Project

This is happening because you've added the column in the middle of the CREATE TABLE script. This causes a "table rebuild" to happen. I talked about this on my blog a few months ago: SSDT problems: ...
user avatar
  • 27.2k
4 votes
Accepted

SQLPackage resets database recovery model

You're right, as far as I know, that there's nothing in the sqlpackage publish options that would change the recovery model. That property is set in the dacpac. If you have access to the source code ...
user avatar
  • 27.2k
3 votes
Accepted

Why is the 'AS' table alias keyword required in Visual Studio (Database projects)

I think this is happening because you're qualifying the database name in the query. So remove **DBName** form the select clause; Visual Studio would then accept it.
user avatar
3 votes

Increasing timeout period for schema compare

Advanced settings in connection has that ability
user avatar
3 votes
Accepted

Separate license needed for Visual Studio 2012 SQL Server database projects?

You don't need a special SQL Server license to use Visual Studio database projects. As mentioned in srutzky's answer the database projects are driven by SSDT which is a free download. If you are ...
user avatar
  • 4,722
3 votes
Accepted

How to solve "ORA-12514: TNS:listener does not currently know of service requested in connect descriptor" error?

I do not have any clear explanation for this problem solution. However I used SID instead of service name in connection string and it worked. Edit: A service name is more flexible than a SID would be....
user avatar
  • 195
3 votes

SSDT Drop and Recreate Tables when nothing has changed

There are several things that can cause this kind of "table movement" or "table rebuild" action to be generated by the SSDT publish process. Expression Standardization The most common reason I've ...
user avatar
  • 27.2k
3 votes
Accepted

Foreach Loop Enumerator with multiple File Names

If I understand correctly what you are trying to do I don't think you should put your expression in the Directory property. I think you need to put: Your directory name (C:\NewExcelFile\) in as the ...
user avatar
  • 15.4k
3 votes

MySQL - "Visual Studio must be installed" - but it is?

I had this issue, and it turned out to be because I didn't have the .NET workload installed in Visual Studio. You need to either select it on installation, or re-run the installer, select 'modify', ...
user avatar
2 votes
Accepted

Cannot connect from computer to server database

Have you turned on TCP/IP access in the SQL configuration manager? It's off by default for security reasons and is the first thing you have to turn on for remote DB access. You will also need to ...
user avatar
  • 471
2 votes

Separate license needed for Visual Studio 2012 SQL Server database projects?

I think you mean SSDT (SQL Server Data Tools) which handles Visual Studio Database projects, but can be run independently of Visual Studio. Look into the documentation for SSDT. Start here: Download ...
user avatar
2 votes

SQL Server 2014 SSIS Package Ignores Script Task when running as AGENT

That occurred because VS 2015 was built to support only SQL server 2016 and you probably deployed the package under SQL Server 2014 or lower(unsupported versions). With the latest version of Data ...
user avatar
2 votes

The following system error occurred: No mapping between account names and security IDs was done

from the SQL management studio, connect to Analysis services and go to Roles, under the roles, the user that has been removed from active directory will appear in question marks "????????????????" , ...
user avatar
  • 2,756
2 votes

SSDT project with working linked server references gets SQL71562 warning

According to the message shown in the Question, this is actually a warning ("warnung") and not an error. An error will stop the build process and prevent the project from being published to the server....
user avatar
2 votes

visual studio database project - publish did not include drops but schema compare did

Visual Studio DB Projects seems to be a poor choice for managing db changes. There are so many different settings that must be set to get the desired effect like setting the "Drop objects in target ...
user avatar
2 votes

Installing SQL Server and Visual studio side-by-side

There is actually no official guide (AFAIK) for which one you should install first but based on my personal experience here is what I recommend: If you are just installing the management components ...
user avatar

Only top scored, non community-wiki answers of a minimum length are eligible