Here is something that is not documented very well. In SQL Server Data Tools projects we have the ability to include SQLCMD variables. The idea is to allow access to a different set of resources at development time without getting compile time errors. In the example below I have variable called LinkedServer that points to … More SQL Server Data Tools – Local SQLCMD Variables