Questions tagged [visual-studio]
Use the tag Visual Studio when you are having issues using Visual Studio in combination with a database system.
37
questions with no upvoted or accepted answers
6
votes
0
answers
256
views
Using the Schema Generation Wizard to regenerate a previously-generated schema
Lately, I've been trying to clean up a group of projects that my company received from an outside contractor. Among them is an SSAS cube, with an associated data warehouse.
The contractors generated ...
5
votes
1
answer
626
views
Reinitialize Table Values in SQL SSDT Unit Testing
I am creating SQL Server Unit Tests. We are testing various stored procedures.
In Unit testing principles, it is good practice to setup a small database table, populate values, and tear down (...
4
votes
0
answers
198
views
Azure SQL DB migration from Visual Studio raises collation error
I want to run a migration in my Azure hosted database. The migration works perfect in several local machines. When I try targeting the Azure database it raises the following exception:
Column X is ...
3
votes
0
answers
1k
views
View(df) in R throw (function(x, df1, df2, ncp, log = FALSE))
I connected R with SQL Server (in Visual Studio 2017) the connection succeeded this is Setting.R
settings <- as.environment(list())
dbConnection1 <- 'Driver={SQL Server};Server=
(local)...
2
votes
0
answers
614
views
VS 2019 - Schema Compare - "The certificate chain was issued by an authority that is not trusted" when TrustServerCertificate=True
I'm trying to do a schema compare in VS 2019 with Active Directory Password Authentication. The account I'm using works in SSMS, but fails in VS with the following error, even when ...
2
votes
0
answers
413
views
SSRS 2016 / VS 2015 Editing text in tablix's textbox very slow in designer
Same issue as described here: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/f6bf89cd-75de-49f9-8a3a-743419ecd631/ssrs-2016-editing-text-in-a-textbox-very-slow-in-the-designer?forum=...
2
votes
0
answers
32
views
SSRS Web Reference Service Not Found
I'm attempting to add a Web Reference to my Visual Studio Web API to link my existing SSRS server to said API. I'm on the Add Web Reference page and I enter the proper URL and the webpage appears in ...
2
votes
0
answers
1k
views
What is the <project name>.sqlproj.user file, and how is it created?
I want to move a .sln file to a directory above where it is currently located (because right now it's in a project directory, which isn't semantically correct). The project is called 'pName', and ...
2
votes
1
answer
588
views
Split SSIS project in to multiple files to avoid merge hell
Since SSIS does not like being merged nicely I was wondering how to have a big SSIS package split up. With the idea of having multiple devs working on this simultaneously, and a minimal chance of ...
2
votes
0
answers
81
views
How to ignore spatial index?
When i do Schema Compare in Visual Studio i see that spatial index in table was changed and this changes will included in generated script. But i do not want see this changes in my script. It's ...
2
votes
0
answers
505
views
(VS Comm./VB6) How to Select from 2 different data sources/formats in one query?
I have two working TableAdapterQueries in my project, one selects from a MySQL database on a virtual server I own, the other is an Oracle PL/SQL database on a separate server.
The data (and datatypes)...
1
vote
0
answers
48
views
How would I connect to a SQL Server (running in a VM using Ubuntu Server), using Access or Visual Studio on my host?
I have tried to connect various ways already and have not been successful. I need a more specific guide on how to/if you can connect this way. I have specific limitations that you need to account for, ...
1
vote
0
answers
2k
views
SQL server job agent fails to execute SSIS package, the package runs fine manually
I have a job which executes two packages. Step 1 is a package which is no longer executing under the job agent although it was executing fine before the server reboot. The package executes fine ...
1
vote
0
answers
629
views
SSDT Schema Compare shows same objects to add and delete in destination
When using schema compare, it shows the objects in dbo schema as objects to add in destination and same objects to delete as well. After inspecting the definitions, they appear to be the same. Why ...
1
vote
0
answers
5k
views
'The INSERT statement conflicted with the FOREIGN KEY constraint
I am wanting to add insert into my uspInsertUserRoles procedure:
CREATE PROCEDURE [dbo].[uspInsertUserRoles]
@RoleID INT,
@UserID INT
AS
BEGIN
INSERT INTO tblUserRoles(RoleID, ...