I'm using views and stored procedures that reference a linked server:
SELECT Id, Name FROM [LinkedServer].Database.dbo.FooView
I would like to hide the
[LinkedServer].Database or at least the
[LinkedServer] part of my views and stored procedures. This way I would be able to have "server-agnostic" code, that would be easily compared between production and dev servers.
This could be done at the server level (like the linked server) or at the database level (where the views and the stored procedures using it are).