In a project on which I am performing maintenance, I am referencing a database stored on another server. This reference was previously pointing at a database on the same server, but my testbed server isn't large enough to store both databases, so I'm having to refer back to the live database.

Anyway, whoever created this application made use of SQL Views, and I have found that when trying to edit the view, that it cannot reference an external database.

The existing reference is to `myDatabase.dbo.tableName`. When I try to change that to `[MyServer.com].myDatabase.dbo.tableName` moving away from the editor removes all of the square brackets, leaving me with `MyServer.com.myDatabase.dbo.tableName` which is not a proper table reference.

Any ideas what I can do to fix this?