SQL Server: Linked Servers in a Development Environment

We were trying to figure out a way of having a dynamically encoded database name in our sql queries for a series of reports working off two databases. We needed to have the second database on a different server and we wanted to replicate this on our development environment as well as making deployment easier.Continue reading “SQL Server: Linked Servers in a Development Environment”