database reference for Linked Server Object

Question

Hi all,

I imported a SQL Server 2016 database into a VS 2022 SQL Server Project and the import finished without exceptions.

When I tried to build the project, though I got a whole bunch of warnings about non existent referenced objects and that is because the stored procedures are referencing other databases in the same instance.

How do I add databases that are referenced through Linked Servers?

Thanks,

vv

Answer 1

How do I add databases that are referenced through Linked Servers?

Through linked server? Not possible in a SSDT project.

You can additional import the other databases as well, but cross-database/cross-server access isn't really working well in SSDT.

See Add Database Reference Dialog Box