All Questions
Tagged with visual-studio linked-server
3
questions
1
vote
1
answer
911
views
View with OPENQUERY won't build in SSDT project
I have an existing database that I'm trying to set up as a database project. I'm not able to get the following statement to build:
CREATE view [dbo].[VW_SOMEVIEW] as
SELECT * FROM OPENQUERY ([...
- 33
5
votes
1
answer
7k
views
SSDT project with working linked server references gets SQL71562 warning
I have a VS 2013 solution with two database projects.
One of them, let's call it the "worker" is supposed to get deployed to about 10 different production servers.
The other one, that is supposed ...
- 4,797
10
votes
1
answer
38k
views
Using a linked server with OPENQUERY in a database project
I have a SQL Server 2008 running a database I want to throw in TFS. Therefore I used a Visual Studio 2013 database project where I imported the DB. After fixing a bunch of errors I'm stuck with only ...
- 191