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 ...
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....
- 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 ...
- 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 ...
- 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.
- 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 ...
- 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 ...
- 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 ...
- 12.8k
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
- 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 ...
- 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 ...
- 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?
- 41
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 ...
- 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 ...
- 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: ...
- 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 ...
- 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.
- 146
3
votes
Increasing timeout period for schema compare
Advanced settings in connection has that ability
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 ...
- 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....
- 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 ...
- 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 ...
- 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', ...
- 31
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 ...
- 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 ...
- 65.8k
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 ...
- 121
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 "????????????????" , ...
- 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....
- 65.8k
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 ...
- 21
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 ...
- 12.8k
Only top scored, non community-wiki answers of a minimum length are eligible